Hi folks,
Three questions about pg_dump (that might be a feature request). Let me
know if pg_dump is not the best tool for this sort of thing.
1. Can I pg_dump only non-table information from the command line
e.g. single function, all functions, trigger definitions?
2. Can I pg_dump schema o
I think that query should work. Hmmm... Weird...
I tried that in my database and it is working.
What do you mean by this? " If i use a list instead of a subquery it works
normaly but it's not easy to manage it like this."
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED
--- Steve SAUTETNER <[EMAIL PROTECTED]> wrote:
> SELECT * FROM famille WHERE famille_code NOT IN
> (SELECT DISTINCT famille_mere_famille_code FROM famille);"
try
select * from famille f1 where not exists
(select 1 from famille f2
where f1.famille_code = f2.famille_mere_famille_code);
__
On Sun, 13 Nov 2005, Steve SAUTETNER wrote:
> Hi,
>
> I have a table named "famille" whose structure and content is :
>
> famille_code | famille_mere_famille_code | famille_libelle |
> famille_niveau
> --+---+---+-
> ---
> 00
