Douglas Rafael da Silva [EMAIL PROTECTED] schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi,
I'd like to do a query where can be possible I access tables from
diferent databases on the same query.
On MySQL, I do:
SELECT People1.PersID, People1.Name, Result1.Value,
Hi Steven,
you may use COALESCE. This function should have the same behaviour as
Oracle's nvl. For documentation look at
http://www.postgresql.org/idocs/index.php?functions-conditional.html
Andre
Steven Dahlin [EMAIL PROTECTED] schrieb im Newsbeitrag
9qj13u$2v5l$[EMAIL
- Original Message -
From: trebischt [EMAIL PROTECTED]
Subject: [SQL] To query many tables.
Hi,
The query looks like this:
select * from table1 f, table2 s, table3 t, table4 fo, table5 fi,
table6 si, table 7 se, table8 e, table9 n, table10 ten, table 11 el,
table 12 tw ...
where
Can you post the exact errormessage?
- Original Message -
From: Richard NAGY [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 14, 2001 12:11 PM
Subject: [SQL] SQL request change when upgrade from 7.0.2 to 7.1.3
Hello,
Recently, I have upgraded my postgresql server
- Original Message -
From: Joseph Shraibman [EMAIL PROTECTED]
Subject: Re: [SQL] WHERE on an alias
If I try to put a distinct on in my subselect int the from I get:
ERROR: SELECT DISTINCT ON expressions must match initial ORDER BY
expressions
what does that mean?
You need to (at
Hi,
if you translate your (english) idea striktly to SQL, you'll make it ;-)
Now, i need to get the details of all employees who did
receive NONE of the salesorders. ie.. i wish to select the
records of table 'employee' whose 'emp_id' are not
there in table 'salesorder'.
SELECT *
Hi,
In an effort to do some general cleanup in my database functions, I
dumped the schema (pgdump -s) and the data (pgdump -a) to seperate text
files.
I'm using a similar method for my own project. But I dump the data with
the -d or -D option. This ist not as fast as the raw copy but more