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

help ?

From: "utomo restu" <utomo(at)linuxmail(dot)org>
To: pgsql-php(at)postgresql(dot)org
Subject: help ?
Date: 2003-05-30 05:00:17
Message-ID: 20030530050017.15862.qmail@linuxmail.org (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-php
Dear All

I'am a new user in postgresql, i want to ask about :

1. The one who is intended with STORED PROCEDURE, 
   how its implement and what its surplus. 
   Version POSTGRESQL that how much possess STRORED PROCEDURE. 

2. In when I make the function as follows:
   
   CREATE FUNCTION forward(CHAR(10))
   RETURNS CHAR(10), CHAR(30)
   AS 'select no_id, name FROM address where no_id=$1;'
   Language 'sql';
   
   To step forward orders the error ... 
   Which wants I asked, how make a function that can step forward
RETURNS More than a column 
   (I want to show 2 columns i.e. no_id and Name) ?

best regards
-- 
______________________________________________
http://www.linuxmail.org/
Now with e-mail forwarding for only US$5.95/yr

Powered by Outblaze

Responses

pgsql-php by date

Next:From: scott.marloweDate: 2003-05-30 14:47:27
Subject: Re: [PHP] help ?
Previous:From: Chadwick RolfsDate: 2003-05-29 19:53:14
Subject: Re: [SQL] faster output from php and postgres (one resolution)

pgsql-general by date

Next:From: Karel ZakDate: 2003-05-30 05:41:44
Subject: Re: to_char (was Re: fomatting an interval)
Previous:From: Steve LaneDate: 2003-05-30 04:31:24
Subject: Re: Moving a table to a different schema

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