On Fri, Feb 16, 2001 at 09:36:23AM -0500, Bruce Momjian wrote:
snip
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. SETOF
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 SQL
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|
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 load off 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 "Give
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
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
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 in
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
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
18 matches
Mail list logo