> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Steve - DND > Sent: 15 March 2005 05:55 > To: Mark A. Taff; pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] Execute a function? > > > Been a _very_long while, but try: > > > > SELECT my_function(param_1, param_2) As Answer; > > Yep, that did it. I'm such a newb with PG, still trying > everything the MSSQL > way first. Is that the proper way to do it even if you have a > function that > returns void?
Yeah, though you'd omit the 'As Answer' (which will fold to lower case without quotes btw). That bit just gives the resulting column an alias. Regards, Dave ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])