> Is it possible to return an array from a plpgsql function??
AICR, it is impossible. In addition, it's not suggested using arrays at
all: the array based logic is foreign from SQL solutions. In fact
PostgreSQL doesn't have a good array support. My friend who built our
logic data model, said that
Hi, this query gives different strange results:
select to_char(now()::abstime,'YYMMDDHH24MI');
I get e.g. a "backend closed the channel unexpectedly..." error with
successful or failed resetting attempt (indeterministic)
or
ERROR: to_char/to_number(): not unique decimal poit
or
NOTICE: Por
On Thu, 14 Dec 2000, Kovacs Zoltan Sandor wrote:
> Hi, this query gives different strange results:
>
> select to_char(now()::abstime,'YYMMDDHH24MI');
the result:
ERROR: to_char/to_number(): not unique decimal poit
is right, because we have two to_char():
to_char(int, text)
There actually is a model of tree structures in SQL databases which is
different from those mentioned earlier in that it represents the tree
as nested sets (ie. nodes are subsets of parent sets (parent nodes)).
There is a huge advantage in this model as it eliminates the need for
recursion. For
Tom Lane wrote:
> Kyle <[EMAIL PROTECTED]> writes:
> > This worked great until I put a real big file in (about 5M). Then, when
> > I tried to fetch the file, it seemed really slow (about 60 seconds). I
> > tried reassembling the file in the frontend instead and my time dropped
> > to about 6 sec
Kyle wrote:
> I'm using 7.0.1 with a TCL frontend.
>
> I have a schema that splits large files into tuple-sized bites and
> stores them in a table. This was done before TOAST in order to store
> large files.
>
> I have a backend TCL function that re-assembles the file like this:
>
> -- Fetch the
somebody already showed table structure, but i'll ad some more code to this:
table:
CREATE TABLE groups (
id INT4 NOT NULL DEFAULT NEXTVAL('groups_seq'),
parent_idINT4 NOT NULL DEFAULT 0,
name TEXT NOT NULL DEFAULT '',
active BOOL NOT NULL DEFA
> A problem (IMHO it's not problem) with 'now()::abstime' is in 7.1 too.
> But why you not use directly now()?
My aim is to get this format for the time '5 minutes ago'. So I need
something like
select to_char(now()-'5 minutes','YYMMDDHH24MI')
but this doesn't work due to the missing type conv
Title: RE: [SQL] to_char() causes backend to close connection
select to_char(now()-'5 minutes'::interval,'YYMMDDHH24MI') seems to work
Ben
> -Original Message-
> From: Kovacs Zoltan Sandor [mailto:[EMAIL PROTECTED]]
> Sent: 14 December 2000 15:49
> To: Karel Zak
> Cc: [EMAIL PROTEC
Hi all!
I'm using postgresql7.0.2
I did
ipcclean
and then
pg_ctl stop
then I tried to start up again the DB server as usual
nohup postmaster -i > pgserver.log 2>&1 &
I got this error:
FATAL 2: Read("/usr/local/pgsql/data/pg_control") failed:2
FATAL 2: Read("/usr/local/pgsql/data/pg_control") f
I can´t compile fulltext index, i need step by step explain about this
process and Where are fti.so file? please help me to implement this feature.
I have Postgresql 7.0 in linux red-hat
Thanks
Hi, ALL
This is my first time in this list... Sorry by any inconvenience
I need a TRIGGER thats runs whith POSTGRES permissions. I´ll give an
ODBC
connection for programmers that don´t need to know the "rules" of my
Data
Base.
So, I´ll creata an "fake" table, and with a BEFORE INSERT TRIG
Hi all!
I'm using postgresql7.0.2
I did
ipcclean
and then
pg_ctl stop
then I tried to start up again the DB server as usual
nohup postmaster -i > pgserver.log 2>&1 &
I got this error:
FATAL 2: Read("/usr/local/pgsql/data/pg_control") failed:2
FATAL 2: Read("/usr/local/pgsql/data/pg_control") f
Hi,
miguel sofer wrote:
>
> I once started writing a small paper on this subject; it is still in a
> rather preliminary state.
>
> You can download the draft (and some ill documented code, 53kB) from
> http://www.utdt.edu/~mig/sql-trees
ah, this looks very, very nice!
on page 5ff you describ
Hi,
>
> > I once started writing a small paper on this subject; it is still in a
> > rather preliminary state.
> >
> > You can download the draft (and some ill documented code, 53kB) from
> > http://www.utdt.edu/~mig/sql-trees
>
i guess, with base 160 encoding there might be a problem: if post
Hi Security-Master,
[EMAIL PROTECTED] wrote:
>
> When [EMAIL PROTECTED] sent e-mail to [EMAIL PROTECTED]
>(1/255/1)
> The message was blocked by TFS Secure Messaging
> When [EMAIL PROTECTED] sent e-mail to [EMAIL PROTECTED]
>(1/255/1)
> The message was blocked by TFS Secure Messaging
please c
As of a few moments ago, Dana Reed is an ex-subscriber to pgsql-general.
Evidently he/she is about to be an ex-subscriber to pgsql-sql as well.
Most mailing list admins take a very dim view of mail software that
sends bounces to the original author of a mailing-list message, rather
than to the ma
oh, wait, you didn't want me to remove dana from all lists? :) if
offensive on one, I figure its offensive on all ... saves time, no?
On Thu, 14 Dec 2000, Tom Lane wrote:
> As of a few moments ago, Dana Reed is an ex-subscriber to pgsql-general.
> Evidently he/she is about to be an ex-subscrib
Hi,
The Hermit Hacker schrieb:
>
> oh, wait, you didn't want me to remove dana from all lists? :) if
> offensive on one, I figure its offensive on all ... saves time, no?
hmm, perhaps the admin of him give OK to receive mails in future ... ;-)
Ciao
Alvar
--
Alvar C.H. Freude | [EMAIL P
19 matches
Mail list logo
