On Fri, 20 Dec 2002 12:41:52 -0500 (EST)
Bruce Momjian <[EMAIL PROTECTED]> wrote:
> > I also expect that pg_dump/pg_dumpall will have syntax like:
> >
> >pg_dump -t schema.* database_name
>
> Yes, it is on the TODO list.
>
That's g
no way to do. Pg_dump will come
to output tables every schema in the future version(7.3.x or later),
I guess.
I also expect that pg_dump/pg_dumpall will have a syntax like:
pg_dump -t schema.* database_name
Regards,
Masaru Sugawara
---(end of broadcast)--
7;
>
Uh, there is no error in MS Access, but are two errors in PG: "+"and "iif()".
You need to use "||" and "CASE WHEN ... THEN ... END". See docs.
Regard,
Masaru Sugawara
---(end of broadcast)---
t join
auxcidades a1 on (a1.id = c1.ref_cidade)
Regard,
Masaru Sugawara
> ok,
> table ctareceber:
> cod_cliente int 4 20
> document varchar 8 NF
> factura int 4 01
> ...
>
>
> table cliente:
> cod_cliente int 4
m not sure what the problems is.
Could you show us the output of the result you hope ?
Regards,
Masaru Sugawara
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
nsert into account values(3, '', 100, 'debit');
select t.id, sum(t.c) as credit, -sum(t.d) as debit,
sum(t.c) - sum(t.d) as total
from (select id, amount as c, 0 as d
from account where action_type = 'credit'
union all
select id
