Skip site navigation (1) Skip section navigation (2)

Re: analyzing query results

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Lonni J Friedman" <netllama(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: analyzing query results
Date: 2007-08-13 22:28:35
Message-ID: 23363.1187044115@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
"Lonni J Friedman" <netllama(at)gmail(dot)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

In response to

pgsql-novice by date

Next:From: Loredana CurugiuDate: 2007-08-14 07:37:47
Subject: Re: [NOVICE] Install two different versions of postgres which should run in parallel
Previous:From: Lonni J FriedmanDate: 2007-08-13 21:51:03
Subject: Re: analyzing query results

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group