Josh,
I'm not sure what you mean by 'builtin C function'.
There is one already
size_t PQescapeString (char *to, const char *from, size_t length);
Or do you mean a String Function like
substring(string [from integer] [for integer])
I would rather call it 'builtin sql function'.
Regards,
Hi Mauricio
Novell, and i think windows and unix as well, have the disk quota feature.
The disk size assigned to a user can be limited. There should also be
warning levels in order to get the sysadmin noticed about a user running out
of space before it's too late. Try on a os related newsgroup,
On Tue, 18 Jun 2002 [EMAIL PROTECTED] wrote:
Hello there
I use the function text_ge(text, text) under version 7.03 and it was just
fine. After upgrading to version 7.2 this function doesn't work anymore.
It is quite possible that text_ge uses local encodings.
However I think it is working
Josh Berkus [EMAIL PROTECTED] writes:
Given the amount of qoute nesting we do in Postgres, I thought that we need a
function that handles automatic doubling of quotes within strings. I've
written one in PL/pgSQL (below). I'd really love to see this turned into a
builtin C function.
Chris, Tom:
Yes, thank you Chris, I meant a builtin SQL function.
Given the amount of qoute nesting we do in Postgres, I thought that
we need a
function that handles automatic doubling of quotes within strings.
I've
written one in PL/pgSQL (below). I'd really love to see this
On Tue, 2002-06-18 at 18:07, Wei Weng wrote:
Is there any disadvantage of using TEXT datatype as opposed to a VARCHAR
datatype with a maximum length, especially when I do searches on them?
There is one big disadvantage that I've found, but might be utterly
unimportant to you. Some applications
On Tue, 2002-06-18 at 18:59, Josh Berkus wrote:
Wei,
Is there any disadvantage of using TEXT datatype as opposed to a VARCHAR
datatype with a maximum length, especially when I do searches on them?
Yes. You can't index TEXT because it's of potentially unlimited length.
--
-Josh
Rudi,
select to_char(date_column, 'Month');
See similar under Formatting Function in the docs.
--
-Josh Berkus
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL
I have no trouble indexing TEXT datatype in postgres-7.x
- Original Message -
From: Josh Berkus [EMAIL PROTECTED]
Yes. You can't index TEXT because it's of potentially unlimited length.
---(end of broadcast)---
TIP 2: you can get off