Re: [pgadmin-support] A question

2002-11-28 Thread Dave Page
; Sent: 28 November 2002 05:27 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] A question > > > My postgresql version is 7.2.1 > I have create a function: > create function returnset(varchar) returns setofcomputers > as ' > select * from computer where

[pgadmin-support] A question

2002-11-28 Thread ÖxÈý
My postgresql version is 7.2.1 I have create a function: create function returnset(varchar) returns setofcomputers as ' select * from computer where hostname like ''%''+$1+''%'' ' language 'plpgsql'; But when I select returnset('aaa') ,it returns: An error has occured in pgAdmin II:frmSQLInput.cm

Re: [pgadmin-support] a question

2002-11-14 Thread Dave Page
SELECT my_function(); In the SQL windows will do it. Regards, Dave. > -Original Message- > From: [EMAIL PROTECTED] [mailto:sunthing@;963.net] > Sent: 14 November 2002 12:09 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] a question > > > How to run a st

[pgadmin-support] a question

2002-11-14 Thread ÖxÈý
How to run a storeprocedure or function in pgadminII ? »¶Ó­Ê¹ÓÃ963Ãâ·ÑÓʾÖ(http://www.szonline.net) ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an ap