Hi skarthi,
On Wed, 2007-04-11 at 16:29 -0700, Karthikeyan Sundaram wrote:
> The reason why I am asking is, we are building an interface layer
> where all our users will have a view. They shouldn't know anything
> about how and where the data is stored in the table. They can be seen
> only by
Regards
skarthi> Date: Wed, 11 Apr 2007 19:00:23 -0400> From: [EMAIL PROTECTED]>
Subject: Re: [ADMIN] [SQL] Urgent help in bit_string data type> To: [EMAIL
PROTECTED]> CC: pgsql-admin@postgresql.org; pgsql-sql@postgresql.org> > Hi
skarthi,> > On Wed, 2007-04-11 at 15
Hi skarthi,
On Wed, 2007-04-11 at 15:01 -0700, Karthikeyan Sundaram wrote:
> create table test_a (b bit(3));
>
> create view test_vw (b1, b2, b3)
> as select
> to_number(substring(b,1,1)::int,'9') as b1,
> to_number(substring(b,2,1)::int,'9') as b2,
> to_number(substring(b,3,1)::int,'9') as b3 f
; Date: Wed, 11 Apr 2007 17:44:01 -0400> From: [EMAIL PROTECTED]> Subject: Re:
> [ADMIN] [SQL] Urgent help in bit_string data type> To: [EMAIL PROTECTED]> CC:
> pgsql-admin@postgresql.org; pgsql-sql@postgresql.org> > Hi skarthi,> > On
> Wed, 2007-04-11 at 13:30 -
Hi skarthi,
On Wed, 2007-04-11 at 13:30 -0700, Karthikeyan Sundaram wrote:
> insert into test_a values (to_char(1,'9'));
>
> ERROR: column "b" is of type bit but expression is of type
> text
> HINT: You will need to rewrite or cast the expression.
As su
Hi Gurus,
I have a table with datatype as bitstrings
create table test_a (b bit(3));
insert into test_a values ('111');
This will convert a bit to a number
==
select to_number((substring(b,1,1)::int),9)+3 from test_a;
How will I convert a Number to a bit
--
Title: Urgent Help : Use of return from function/procedure.
- Original Message -
From:
Anagha
Joshi
To: [EMAIL PROTECTED]
Sent: Sunday, June 22, 2003 11:42
PM
Subject: [SQL] Urgent Help : Use of
return from function/procedure.
Hi, I'm new to
pos
On Monday 23 Jun 2003 6:42 am, Anagha Joshi wrote:
> Hi,
> I'm new to postgres and using version 7.2.4
>
> I've created a trigger and function which does the following:
> trigger 'T' fires after insert on a spcific table takes place
> and it executes function 'F'
>
> Function 'F' returns the
Title: Urgent Help : Use of return from function/procedure.
Hi,
I'm new to postgres and using version 7.2.4
I've created a trigger and function which does the following:
trigger 'T' fires after insert on a spcific table takes place and it executes function 'F'
Function 'F' retur
I suspect you have a group with a dangling reference to a deleted user.
What do you get from "select * from pg_user" and "select * from
pg_group" ?
regards, tom lane
another weired thing is,
when I:
select * from pg_group;
it takes about 2 minites to return, it took just a tick before,
it seems that some sys tables has been locked for a timeout.
Thanks.
Jie LIANG
St. Bernard Software
Internet Products Inc.
10350 Science Center Drive
Suite 100, San Die
Tom,
I think one of system file has been crupted.
I tried to drop some user then db is hangged there forever,
so kill that session, when I relogin and type
urldb=# \z categories
NOTICE: get_groname: group 2 not found
The connection to the server was lost. Attempting reset: Failed.
!#
and new
12 matches
Mail list logo
