Hi ,
I am running postgres 7.3.4 on Linux 7.2. I wanna print
'Not Supplied' if 'c1' column of datatype - 'timestamp' is null. For
that I am using case statement
SELECT
CASE WHEN c1 IS NULL THEN
'Record_Not_Found'ELSE c1 END as approval_date
FROM t1;
ERROR: Bad timestamp external re
On Tuesday 25 November 2003 12:37, Kumar wrote:
>
> SELECT
> CASE WHEN c1 IS NULL THEN 'Record_Not_Found'ELSE c1 END as
> approval_date FROM t1;
> ERROR: Bad timestamp external representation 'Record_Not_Found'
>
>
> SELECT
> CASE WHEN c1 IS NULL THEN 'Record_Not_Found'::text ELSE c1 END
I'm having a strange problem that, though I found an appropriate thread in the
mailing list archive, archives.postgresql.org seems to be down so I cannot
see what the resolution was.
I have a database "scamp", with my own administrator user and a user "dialup".
Inside the "scamp" database I've
Michael A Nachbaur <[EMAIL PROTECTED]> writes:
> scamp=> select * from Dialup.UserGroup;
> ERROR: dialup: permission denied
You haven't granted USAGE permission on the "dialup" schema to this
user. You need that in addition to select permission on the view itself.
regard
On Tuesday 25 November 2003 09:09 am, Tom Lane wrote:
> Michael A Nachbaur <[EMAIL PROTECTED]> writes:
> > scamp=> select * from Dialup.UserGroup;
> > ERROR: dialup: permission denied
>
> You haven't granted USAGE permission on the "dialup" schema to this
> user. You need that in addition to sele
