Postgres Pro
Downloads
Home   >   mailing lists

Re: Naming of ORDINALITY column - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Naming of ORDINALITY column
Date
Msg-id 51C7BD23.8060301@agliodbs.com
Whole thread Raw
In response to Review: UNNEST (and other functions) WITH ORDINALITY  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Responses Re: Naming of ORDINALITY column  (Dean Rasheed <dean.a.rasheed@gmail.com>)
List pgsql-hackers
Tree view 
On 06/23/2013 08:00 PM, Andrew Gierth wrote:
> OK, let's try to cover all the bases here in one go.

> 1. Stick with "?column?" as a warning flag that you're not supposed to
> be using this without aliasing it to something.

How do I actually supply an alias which covers both columns?  What does
that look like, syntactically?

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

pgsql-hackers by date:

Previous
From: Andrew Gierth
Date:
Subject: Naming of ORDINALITY column (was: Re: Review: UNNEST (and other functions) WITH ORDINALITY)
Next
From: Abhijit Menon-Sen
Date:
Subject: Re: ALTER TABLE ... ALTER CONSTRAINT