Groups > comp.databases.postgresql > #670

PG composite types: select with table alias

X-Received	by 10.182.186.67 with SMTP id fi3mr30765800obc.49.1435693579371; Tue, 30 Jun 2015 12:46:19 -0700 (PDT)
X-Received	by 10.140.101.22 with SMTP id t22mr260644qge.32.1435693579293; Tue, 30 Jun 2015 12:46:19 -0700 (PDT)
Path	csiph.com!optima2.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!ff1no141352igc.0!news-out.google.com!4ni33014qgh.1!nntp.google.com!s91no85541qgd.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.postgresql
Date	Tue, 30 Jun 2015 12:46:19 -0700 (PDT)
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=94.154.220.243; posting-account=DTlboQoAAABzFvdYYFycmbAkaa-1GWs7
NNTP-Posting-Host	94.154.220.243
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<b0cb800b-e478-411b-8a17-56259cf13c14@googlegroups.com> (permalink)
Subject	PG composite types: select with table alias
From	armsoft@ukr.net
Injection-Date	Tue, 30 Jun 2015 19:46:19 +0000
Content-Type	text/plain; charset=ISO-8859-1
Xref	csiph.com comp.databases.postgresql:670

Show key headers only | View raw

I`m trying to select a PG composite type fields in a select with table alias:

SELECT id, 
env.(EnabledTracking).changedby    -- <<<<< here the error referrs
FROM environment env
WHERE env.environmentId = 4

but PG gives an error 'syntax error at or near "("'. I can`t remove the alias as SQL is auto-generated by ORM.

Is there a way to use composite types in select with table alias? No documentation was found regarding this issue.

Back to comp.databases.postgresql | Previous | Next — Next in thread | Find similar

Thread

PG composite types: select with table alias armsoft@ukr.net - 2015-06-30 12:46 -0700
  Re: PG composite types: select with table alias Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2015-07-01 01:11 +0200
  Re: PG composite types: select with table alias armsoft@ukr.net - 2015-07-01 10:37 -0700
    Re: PG composite types: select with table alias Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2015-07-01 20:13 +0200

csiph-web