Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f75BWF643614 for ; Sun, 5 Aug 2001 07:32:15 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f75B42371310 for pgsql-sql@postgresql.org; Sun, 5 Aug 2001 07:04:02 -0400 (EDT) (envelope-from news) From: Allan Engelhardt X-Newsgroups: comp.databases.postgresql.novice,comp.databases.postgresql.sql Subject: Using functions in SQL statements Followup-To: comp.databases.postgresql.novice Date: Sun, 05 Aug 2001 12:04:21 +0100 Organization: http://cybaea.com/ Message-ID: <3B6D2835.1B264094@cybaea.com> X-NNTP-Posting-Host: engelhardt.demon.co.uk:193.237.12.86 X-Complaints-To: abuse@demon.net X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.7 i686) X-Accept-Language: en MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 17 To: pgsql-sql@postgresql.org X-Archive-Number: 200108/40 X-Sequence-Number: 4261 I would dearly love to do CREATE GROUP foo WITH USER CURRENT_USER; in a script to psql(1), but this does not appear to be supported by the parser. Two questions: 1. Does anybody have a good work-around for this? 2. Is there a document somewhere that says where functions are allowed in SQL statements? --- Allan.