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
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
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
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
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
