"Douglas Rafael da Silva" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
> Hi, Andre !
>
> Maybe yes, maybe not. I have 6 companies of the same group, little but
> they are like as, and they share the main database. But there are data
> that are specifi
"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.
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 PROTECTED]">news:9q
- 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
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
- 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
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 fle
