On Fri, Feb 16, 2001 at 09:36:23AM -0500, Bruce Momjian wrote:
>
> Funny you should mention PHP. I talked to Rasmus about the email volume
> when I first met him in the fall. He said the volume of email is so
> great that just reading the subject lines takes a long time.
>
> We aren't there
Feite Brekeveld wrote:
>
> I want to return mre than 1 arg
>
> create function func(varchar)
> --> returns var1, var2
> as '
> ...
> '
> language 'sql';
>
> How to deal with the return : The manual says to use SETOF can't figure
> out how that works no examples are given.
Not quite right.
Tom Lane wrote:
[snip]
> > Hmmm...I'd hate to have two indexes on every field I query like this, one
> > case-senstive, one case-insensitve (like the one you create here). Is
> > there a configuration option or something that will tell pgsql to do
> > case-insensitive comparisons (kinda like MS
Today is the last day for O'Reilly proposals to be submitted:
http://candle.pha.pa.us/oreilly/
I will make decisions on Monday and inform submitters. Once the list is
finalized and accepted by O'Reilly, I will post the schedule.
--
Bruce Momjian| http://cand
Peter Eisentraut wrote:
>
> Richard writes:
>
> > Would this lighten the work load on the folk that are
> > currently maintaining the docs? Would it lighten the
> > work load for the core developers? Would it stimulate
> > the development of richer documetation? Would it draw
> > some of the
Tom Lane wrote:
[snip]
That's a very good explanation, thanks. Is it possible to get that
explanation into the docs at that page I mentioned above?
> I'd like to see the feature brought back, myself, but I dunno when it
> will get to the top of someone's to-do queue.
I'd like that too, but the
Martijn van Oosterhout writes:
> Well, one thing would be is that it would make it easier for other
> people to submit changes to a particular page on the docs. You can just
> go there and submit a change. Sending a patch much harder.
The policy for documentation submissions has always been "Giv
Through Konsole, the Up, Down, Left, Right keys work properly, but through
psql the keystrokes seem to be wrong:
instead of up (for scrolling in the internel buffer) it appears ^[[A
Down ^[[B
Right ^[[C
Left ^[[D
Back_del (ok)
Forward_del ^[[3~
It happened when I upgraded Mandrake from 7
set nomail
Richard Huxton <[EMAIL PROTECTED]> writes:
> You can also return a tuple like:
> create function whole_row() returns foo as ...
> But - that can only be used to feed into another function, not in a
> "raw" select statement.
You can make a function returning tuple (or setof tuple), but there
are a
Is there a function reference for Postgresql anywhere? I can't find one
in the standard documentation.
--
Bruce
If I wanted to create a table in such a way that the default value of
one column is the value of another column (or the oid value), is there
a way to do that in the CREATE TABLE statement (with the DEFAULT
keyword, I'd imagine)? Or would I need to create a trigger?
--
Bruce
The DBD::Pg perl module for some reason has a limit of 8140 bytes when
inserting, and I don't see why (yeah, I'll be contacting the authors there
too), but I thought I'd ask here... I'm writing a Postgres-backed mail
client, and storing emails in the database is obviously a little difficult
wh
In pre 7.0 versions there was an 8k query size limit and in all pre 7.1
versions a limit on the size of a field (BLCKSZ from 8k (default) to 32k)...
I'd say it's either in there to prevent one or the other.
Of course 8140 isn't quite 8k but *shrug*..
-Mitch
- Original Message -
From:
Bruce Richardson writes:
> Is there a function reference for Postgresql anywhere? I can't find one
> in the standard documentation.
http://www.postgresql.org/users-lounge/docs/7.0/postgres/functions.htm
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
On Sun, 18 Feb 2001, Martijn van Oosterhout wrote:
> Tom Lane wrote:
>
> [snip]
> >
> > Then why are you bothering to maintain a case-sensitive index?
> >
> > There's no free lunch available here; if you think there is, then you
> > are misunderstanding what an index is. Either the index is i
Hi,
Is there a way to get a dictionary back in the (or almost the) same way
the database is created ?
When defining:
create table xxx (
id varchar(10) not null,
blabla varchar(100)
);
create table refxx (
id varchar(10) not null,
other values ...
primary key(id),
foreign key(
Hi Folks,
I've got a question. Users that use the web-based databases that I've
recently written (cgi-perl and pgsql) sometimes come up with errors when they
input information. I have realized that I need to write some very rigorous
error-checking routines in order to make sure that whatever t
18 matches
Mail list logo
