Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #670

PG composite types: select with table alias

Show all headers | 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