> SELECT id, title,publishdate,categoryid FROM articles WHERE
> upper(title) ~ '(BLACK|SERIOUS|SAM)[[:>:]]'::text ;
>
> I think the proiblem is in trnsalte, not in regexp
>
> If you have installed apprporiate character encoding in Postgres,
> 'upper' will work!
>
> Vladimir
Thanks for the adv
Running 7.0.2 on Alpha/RedHat 6.2 256MB RAM
In order to implement a fulltext search, I have a func that parses list
of words and creates a regexp query with things like [[:<:]]( word |
word | ... )[[:>:]]
That query then is passed to backend...
Now the strange thing:
gamenet=# SELECT id, tit
Hello,
do you happen to know, if there is any sqlserver that WON'T handle
inserting default value if it is not specified in the INSERT field list?
I am particularly interested in ORACLE, INFORMIX and MYSQL .
Eg.
CREATE TABLE test
(
id integer default 5,
fld1 text
);
INSERT INT
> PLEASE ADVISE HOW I SHOULD ALTER THE COMMAND:
>
> <$NOW;DD;>
>
> TO GIVE ME A DATE THAT IS X DAYS FORWARD
>
> ie: I WISH TO REPRESENT A DATE IN FORM WHICH IS A 7 DAYS FORWARD
> OF THE DATE NOW.
( now() + '7 days'::interval )::date (or ::datetime, whichever you
need)
Emils
ss which makes it
operate badly with Postgres and I really can't recommend it as a
frontend application, although I know there are people who use it
quite successfully.
On a side note - pls reply privately - what Win frontends (apart from
web) have people used with Postgres, which work OK f
Hello,
I must confess I have always been a bit baffled by the GROUP BY,
therefore I would appreciate if you could tell me if there's a better way:
I have the table "items":
id | integer | not null default nextval('items_id_seq'::text)
seller_id| integer | not null
materi
Subject:[SQL] renaming columns... danger?
> I just discovered that doing an alter table ... alter
> column (to rename a column) does not do a complete
> rename throughout the database.
> shouldn't rename update any index and key definitions?
> I'm very frightened right now, beca
Subject:[SQL] renaming columns... danger?
> I just discovered that doing an alter table ... alter
> column (to rename a column) does not do a complete
> rename throughout the database.
> shouldn't rename update any index and key definitions?
> I'm very frightened right now, beca
I have the following tables:
**
Table "articles"
Attribute | Type | Modifier
-+-+--
id | integer |
title | text|
authorid| integer |
sourceid| integer |
createddate | date|
createdtime | time|
publ
From: Fabrice Scemama <[EMAIL PROTECTED]>
> Try this:
> http://www.rkirkpat.net/software/
> > parallel regression testing's initdb stage fails with a core file and
> > message:
> >
> > FATAL: s_lock (2030d360) at spin.c:116, stuck spinlock. Aborting.
> > FATAL: s_lock (2030d360)
RedHat Linux 6.2 on Alphaserver DS10 (egcs-1.1.2, glibc-2.1.3,
libstdc++-2.9.0).
Postgresql-7.0.2 source
Compiles and installs just fine. However, both the regular initdb and
parallel regression testing's initdb stage fails with a core file and
message:
FATAL: s_lock (2030d360) at spin.c:116
On 21 Jul 2000, at 9:41, Markus Wagner wrote:
> which data type should be used to hold references to SERIALs in
external
> tables?
integer I believe.
Actually if you \d a table with a serial you'll see that it's an integer
with DEFAULT clause specified.
This is a test to see if I can post. Seems my last post didn't go
through...
Hello,
I have a table that has to have several fields with different names,
but equal content. Sounds stupid, but it is because I have 2
different programs querying the same table for user information and
each of them uses differently named fields.
Eg. I have fields passwd and password.
When
Hello,
I had a look for 'backup' on the mailing list archives and strangely
enough didn't find a message containing the word in admin, general
and sql mailing lists... I am sure this must have been asked before,
but still:
Would it be possible to backup a db by just copying the dir struct
un
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
I am using Postgres 7.0 on SuSE Linux 6.2 and Postdrv.exe
6.50. (as downloaded from /latest/ dir of PG FTP site
yesterday).
Now, I have experienced 4 issues immediately with Postgres via
ODBC from Access and I was wondering whether you
16 matches
Mail list logo
