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
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
"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 do it with a
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 primary key
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
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
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 not
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