Hi All,
As it is known that any funtion, written in pl/pgsql, can only
retrun one tuple. I am just wondering it were true as well for function
written in C language. I need to write few function that will retrun
mulitiple rows satsifying a certain set of conditions. Where I can get
some ex
Hi All,
I have written a very simply function as follows:
create function song_info(int4) returns setof songs as'
select songs.* from songs
where $1=song_id'
language 'sql';
when iIcall it I get the following:flipr=# select song_info(4);
?column?
GH, svangemond,
> > Many people do the first SELECT on a form, stuff the
> result in a hidden
> > variable, then do the INSERT in the form's handler.
> This prevents the
> > double- (or triple-) clicking of "submit" resulting in
> extra database
> > inserts.
Actually, that raises a very good que
Mr. Naik,
> What's the purpose of Serials in Data types of postgres ?
> TIA
> Sharmad
This topic is more than adequately covered in both the
online documentation and Bruce Momjian's book. If language
or other problems are preventing you from finding the
correct reference, please reply and I'll
What's the purpose of Serials in Data types of
postgres ?
TIA
Sharmad
Hi all,
I am just wondering where can i find the link to down load
PostGreSql7.1 beta versoin . I heard it is very stable my be I can use
it see how many times I tumble on bugs I don't do it intentionally
but it happens to me all the time :)...
Regards.
Najm
Hi Joel!
> http://www.postgresql.org/users-lounge/index.html
Ok, my fault...
> > "cannot create index for the selected field"
> >
> > Then the linked table appears in the tables tab in Access. When trying
> > to open it, I get ("Organisation" is the table to be linked):
> >
> > "ODBC error:
>
