[SQL] Extracting user db tabel info from system tables???

2001-01-05 Thread Marc Cromme
QUESTIONS ON USEFULL JOINS ON SYSTEM TABLES FOR USE WITH PHP-WEBINTERFACE I have some problems on making the right joins on system tables to extract the structure of some user defined tables/databases. I use PostgreSQL 7.0.2 on an RedHat 7.0 box. PROBLEM 1: I tried to make a Foreign key constr

[SQL] Non-procedural field merging?

2001-01-05 Thread Richard Huxton
I have two tables, foo and foo2: richardh=> select * from foo; a | b ---+- 1 | xxx 1 | yyy richardh=> select * from foo2; c | d ---+--- 1 | And I would like to set d to 'xxxyyy' (i.e. merge entries from b). Of course the following doesn't work because the 'd' seen is the one from befo

Re: [SQL] Non-procedural field merging?

2001-01-05 Thread Tom Lane
"Richard Huxton" <[EMAIL PROTECTED]> writes: > I have two tables, foo and foo2: > richardh=> select * from foo; > a | b > ---+- > 1 | xxx > 1 | yyy > richardh=> select * from foo2; > c | d > ---+--- > 1 | > And I would like to set d to 'xxxyyy' (i.e. merge entries from b). You could d

Re: [SQL] Extracting user db tabel info from system tables???

2001-01-05 Thread Stephan Szabo
On Fri, 5 Jan 2001, Marc Cromme wrote: > I have some problems on making the right joins on system tables to extract > the > structure of some user defined tables/databases. I use PostgreSQL 7.0.2 on > an > RedHat 7.0 box. > > PROBLEM 1: I tried to make a Foreign key constraint from the primar

[SQL] pqReadData()

2001-01-05 Thread Najm Hashmi
Hi all, I was trying to simply update single field in one of my tables as given below: fliprdb=# update artist set extrinfo='independent' where artist_id=6; pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or wh

Re: [SQL] Casting

2001-01-05 Thread Peter Eisentraut
Thomas SMETS writes: > I'm removing charaters from a String which should be numbers. > I then want to make calculations on these numbers (calculate the ISBN > number). (You might want to look into contrib/isbn_issn for an isbn type.) > Do I have to cast the char into int's before I can do the c

Re: [SQL] Non-procedural field merging?

2001-01-05 Thread Richard Huxton
From: "Tom Lane" <[EMAIL PROTECTED]> [snipped my Q about merging text fields from one table into another] > You could do it with a user-defined aggregate function (initial > value '' and transition function ||). I am not sure that aggregates > work in an intelligent way in UPDATE --- ie, I am n

Re: [SQL] pqReadData()

2001-01-05 Thread Tom Lane
Najm Hashmi <[EMAIL PROTECTED]> writes: > fliprdb=# update artist set extrinfo='independent' where artist_id=6; > pqReadData() -- backend closed the channel unexpectedly. Hmm. Looks like you hit a backend crash :-(. Hard to say more with only this amount of info. What PG version are you using

[SQL] Postgresql database access

2001-01-05 Thread Marcos Aurélio S. da Silva
Dear Pg experts, I have two databases and i want to refer to one table in a database "X" when i'm using database "Y". Something like this: select * from X.table This causes a parse error. What's the correct sintax? Best regards, Marcos Aurelio Brazil

Re: [SQL] Postgresql database access

2001-01-05 Thread Oliver Elphick
"Marcos =?iso-8859-1?Q?Aur=E9lio?= S. da Silva" wrote: >Dear Pg experts, > >I have two databases and i want to refer to one table in a database "X" >when >i'm using database "Y". Something like this: > >select * from X.table > >This causes a parse erro