Re: [SQL] connecting to postgres server from Access

2001-01-12 Thread Markus Wagner
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: >

[SQL] PostGreSql7.1 beta version

2001-01-12 Thread Najm Hashmi
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

[SQL] Serials

2001-01-12 Thread Sharmad Naik
What's the purpose of Serials in Data types of postgres ? TIA Sharmad

Re: [SQL] Serials

2001-01-12 Thread Josh Berkus
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

[SQL] Re: [PHP] Automatic increment

2001-01-12 Thread Josh Berkus
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

[SQL] SQL funtion

2001-01-12 Thread Najm Hashmi
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?

[SQL] pl/pgsql Limits

2001-01-12 Thread Najm Hashmi
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