Re: [SQL] SELECT substring with regex

egex be simply: "^[\d\-]+mm" for BASE "^[\d\-]+mm (.+)$" for SUFFIX Or are you having to deal with malformatted data too (like "30 -70mm" or "28 mm ")? Emils ---(end of broadcast)--- TIP 9: In versions below 8.0,

Re: [SQL] Outer joins

of the join and null extend even if there are obj_id matches if none of those have att_id=8. Thanks, that worked! 2006/4/28, Tom Lane <[EMAIL PROTECTED]>: Emils <[EMAIL PROTECTED]> writes: > The table structure is: > object_values > == This isn't an outer-join

[SQL] Outer joins?

Am I doing something wrong? As I said my SQL is rusty, but this looked pretty straightforward to me... Thanks in advance, Emils ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command

Re: [SQL] Regexps -- too complex?

ows. SELECT title FROM test WHERE title ~ '(BLACK|WHITE|blahblah|SAM)'; yields 0 rows! SELECT title FROM test WHERE title ~ '(BLACK|WHITE|SAM) *'; also yields 0 rows! I dont think this is right no matter what the characters I am using there. At least it shouldn't, s

[SQL] Regexps -- too complex?

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

[SQL] default value syntax - pg compared to?

ecific "default value" token (which postgres does not support anyway). Will it work for the above other dbs? TIA for answers! Emils ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[SQL] default value syntax - pg compared to?

utting a server- specific "default value" token (which postgres does not support anyway). Will it work for the above other dbs? TIA for answers! Emils ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [SQL] DATE

> 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

Re: [SQL] #DELETED error when using Access 2000 as frontend

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

[SQL] group by: properly?

estion is: assuming I will have quite a lot of rows in the result, will the performance be OK to GROUP BY the resulting text fields rather then by I.item_kind, I.material indexed numeric fields? Is it possible to rewrite the query so that GROUP BY (or any alternative construct) deals with the numeric fields and yet I can receive the textual output (that I need) via a single query? Any comments appreciated, Emils

Re: [SQL] renaming columns... danger?

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

Re: [SQL] renaming columns... danger?

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

[SQL] Q: performance on some selects (7.0.2)?

q Scan on newscategories c (cost=0.00..1.43 rows=43 width=20) EXPLAIN Now, as I understand the thing that slows everything is the Seq scan on articles. I wonder why should it be that the query can't use index? TIA! Emils

Re: [SQL] Q: spinlock on Alpha? (PG7.0.2) - solved

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)

[SQL] Q: spinlock on Alpha? (PG7.0.2)

iated ( especially as I need to move the production server to alpha ASAP :(( )! TIA, Emils

Re: [SQL] referencing serials

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.

[SQL] test

This is a test to see if I can post. Seems my last post didn't go through...

[SQL]

[SQL] trigger or something else?

d you tell which configure option enables that? --enable- plpgsql? Thanks in advamce for any comments. Emils

[SQL] Backup?

of large in my db in future. Thanks in advance, Emils

[SQL] Q:Postgres 7.0 & Access'97?

, considering that a is a boolean field. Same query works from psql monitor. Thanks a LOT in advance for any comments. Emils, trying to make Access frontend work with Postgres backend. -BEGIN PGP SIGNATURE- Version: PGP 6.5.2 -- QDP