Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 777249F9A51 for ; Tue, 21 Aug 2007 16:34:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 80784-08 for ; Tue, 21 Aug 2007 16:34:41 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web31803.mail.mud.yahoo.com (web31803.mail.mud.yahoo.com [68.142.207.66]) by postgresql.org (Postfix) with SMTP id 4653D9F9F37 for ; Tue, 21 Aug 2007 16:34:42 -0300 (ADT) Received: (qmail 14539 invoked by uid 60001); 21 Aug 2007 19:34:27 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=BNoXc2PfJksYjNbVjPSM5ZhGIzVB97T3GeCbhnjmh43nyqUEqyg9mKrnqFVh3/KXG/syqz3kRqfEeHUA2Fkzlnp7AjY2eCzTCdnLoh4GlT1RH92SSlI3X6AyTA9/uTEjUKW+BfV42D+VL1U/PBdG6sqd/97bviNpTMIq4j5JcaA=; X-YMail-OSG: wYutWhIVM1kSjiDv0wJ9o1PYP0opR956Z6FUx3y_shsZPZxicZm7e.qW78LKGvbNZA-- Received: from [12.180.237.138] by web31803.mail.mud.yahoo.com via HTTP; Tue, 21 Aug 2007 12:34:27 PDT Date: Tue, 21 Aug 2007 12:34:27 -0700 (PDT) From: Richard Broersma Jr Subject: SELECT syntax synopsis: column_definition? To: SQL Postgresql List MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <830878.14424.qm@web31803.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/171 X-Sequence-Number: 29109 Can any one give an example of the difference between a column_alias and a column_definition when using a function in the FROM clause? from the manual: http://www.postgresql.org/docs/8.2/interactive/sql-select.html "function_name ( [ argument [, ...] ] ) [ AS ] alias [ ( column_alias [, ...] | column_definition [, ...] ) ]" Regards, Richard Broersma Jr.