* ryan <[EMAIL PROTECTED]> [2004-10-16 11:18:48 -0700]: > Is there any way to reuse a column label in a select list like this: > > SELECT 1 + 1 AS a, a + 1 AS b; > > I vaguely remember being able to do something like this in oracle. Any > ideas? Thanks!
You could nest them... xinu=> select (1 + 1) + 1 as answer; answer -------- 3 (1 row) -- Steven Klassen - Lead Programmer Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Replication & Support Services, (503) 667-4564 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings