MN> March, 23 2005, 8:39:31:
b>> hello guys,
b>> I need help. I have functions but it is saved to pg_toast, when I
b>> dump the database, the function from pg_toast is not copied. so is
b>> there any sql or syntax to view function data ?
MN> xxx:=\d pg-catalog.pg_proc
xxx:=\d pg_catalog.pg_pro
Hello, bandeng.
March, 23 2005, 8:39:31:
b> hello guys,
b> I need help. I have functions but it is saved to pg_toast, when I
b> dump the database, the function from pg_toast is not copied. so is
b> there any sql or syntax to view function data ?
xxx:=\d pg-catalog.pg_proc
xxx:=select procsrc
On Wed, Mar 23, 2005 at 11:39:31AM +0800, bandeng wrote:
> I need help. I have functions but it is saved to pg_toast, when I
> dump the database, the function from pg_toast is not copied. so is
> there any sql or syntax to view function data ?
What exactly do you mean by "it is saved to pg_toast
hello guys,
I need help. I have functions but it is saved to pg_toast, when I
dump the database, the function from pg_toast is not copied. so is
there any sql or syntax to view function data ?
Thanks
Ricky
---(end of broadcast)---
TIP 9: the plan
- Original Message -
From: "Richard Huxton"
To: "Sean Davis" <[EMAIL PROTECTED]>
Cc: "PostgreSQL SQL"
Sent: Tuesday, March 22, 2005 3:59 PM
Subject: Re: [SQL] Self-referencing table question
Sean Davis wrote:
I answer my own question, if only for my own records. The following
query i
On Tue, Mar 22, 2005 at 02:28:08PM -0700, [EMAIL PROTECTED] wrote:
> I have a requirement where I have a table and a view on top of it. I want to
> make some changes so that a user in a given group would be able to
> insert/update
> only on the view (ofcourse i have a rule which inserts/updates t
Hi,
I have a requirement where I have a table and a view on top of it. I want to
make some changes so that a user in a given group would be able to insert/update
only on the view (ofcourse i have a rule which inserts/updates the table) but
not on the underlying table. I tried revoke the insert/upda
Sean Davis wrote:
I answer my own question, if only for my own records. The following
query is about 5-6 times faster than the original. Of course, if
anyone else has other ideas, I'd be happy to hear them.
Sean
explain analyze select from_id,to_id,val from exprsdb.correlation where
from_i
I answer my own question, if only for my own records. The following
query is about 5-6 times faster than the original. Of course, if
anyone else has other ideas, I'd be happy to hear them.
Sean
explain analyze select from_id,to_id,val from exprsdb.correlation where
from_id in (select to_id
I have a table that looks like:
Column | Type | Modifiers | Description
-+--+---+-
from_id | integer | not null |
to_id | integer | not null |
val | numeric(4,3) | |
Indexes:
"correlation_pkey" PRIMARY KEY, btree (
Perhaps it will be better if you put an 'order by' in the select.
SELECT
(( select test1.date
from test test1
where test1.date > test.date order by date limit 1)
- test.date ) AS result from test order by date;
result
42
31
33
25
Re
That's a good one, but it has the disadvantage of
giving a null result row:
insert into test values ( '2004-12-22' ) ;
The SELECT from below gives
result
31
33
25
(null)
42
(5 rows)
Also, I am not sure about the order of values.
Anyway, Béatrice, thanks for your
"[EMAIL PROTECTED]" wrote:
>
> I have a database with several tables that use timestamp without time
> zone type. I upgraded from an older pgsql and have code that does not
> expect the precision in the select output. Is there a way I can get the
> effect of zero precision without modifying all th
13 matches
Mail list logo
