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
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 PR
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.
>
> --
>
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 application
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 Berkus
---(end of broadcast)-
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?
Thanks
--
Wei Weng
Network Software Engineer
KenCast Inc.
---(end of broadcast)---
TIP 3: if postin
On Tue, Jun 18, 2002 at 00:46:59 +0100,
Andy Pearce <[EMAIL PROTECTED]> wrote:
> Hi,
>
> This may be the wrong forum, but I'm sure someone can help!
>
> I'm writing a VB application that uses PostgreSQL as the database backend. Is it
>common practice to create a user id in pgsql for each user
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 thi
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.
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 worki
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.
this statement shows all the records even if the greatest year is 2002 in
ul_datum :
select * from userlog where text_ge(ul_datum, '01.01
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, t
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, C
13 matches
Mail list logo
