Postgres Pro
Downloads
Home   >   mailing lists

Re: Simple SQL - Mailing list pgsql-general

From Terry Yapt
Subject Re: Simple SQL
Date
Msg-id he0bpvgvo7k24opbgt8m93kibcitgiljfg@4ax.com
Whole thread Raw
List pgsql-general
Tree view 
>Is it possible to do something like:
>
>    select 1 as a, a*a;
>
>in postgres?

Perhaps on this way:

SELECT a, a*a FROM
  (SELECT 1 AS a);

Greetings....

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: [SQL] Alias-Error
Next
From: Karsten Hilbert
Date:
Subject: max() over some rows but grouped, within one view def - how ?