Postgres Pro
Downloads
Home   >   mailing lists

Re: analyzing query results - Mailing list pgsql-novice

From Tom Lane
Subject Re: analyzing query results
Date
Msg-id 23363.1187044115@sss.pgh.pa.us
Whole thread Raw
In response to Re: analyzing query results  ("Lonni J Friedman" <netllama@gmail.com>)
List pgsql-novice
Tree view 
"Lonni J Friedman" <netllama@gmail.com> writes:
> Thanks, this is exactly what I need.  Only one question.  What is the
> 'ss' that you have in that query?

Table alias for the sub-select.  The SQL spec says you have to provide
one ... you can leave out the AS keyword, though.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Lonni J Friedman"
Date:
Subject: Re: analyzing query results
Next
From: "Patrick Lindeman"
Date:
Subject: Re: Postmaster start up problems (can't create lock file )