This works:
select
orgid,
case when status = 'y' then '1' else '0' end
from vend
This doesn't:
select distinct
orgid,
case when status = 'y' then '1' else '0' end
from vend
The only difference is the absence of dis
All:
I have the following table:
create table try (
ordnum int4 primary key,
type char(3),
CONSTRAINT type_check CHECK(type in ('bid', 'ord', 'rma'))
);
The named constraint works find here.
However when I do:
> psql ati -c "alter table try drop constraint type
Developers:
I need to create a view that contains a query with an outer join.
Since outer joins are not supported, I used a union.
The problem, now, is that unions are not supported with views.
How soon until this is fixed?
Any suggestions?
Merrill
PGSQL-BUGS:
I recently did a pg_dump of my data from 7.0 and did an upgrade to
7.0.2.
Then I did a: psql "database name" -f "my sql dump file"
The problem is that a table was created that uses a funtion, which
function had not yet been created.
(The function is created later on in the dump file
