Re: [SQL] [NOVICE] Windows 2K Installation difficulties...

mystery. Hmmm... On 1/25/07, *Oisin Glynn* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: Neil Bibbins wrote: > Hello, > > I'm having difficulty installing PostgreSQL 8.2 on Windows 2000. It > gets most of the way through the install

Re: [SQL] Odbc configuration on Localhost

better than the better of dictatorships http://ezequiasrocha.blogspot.com/ <http://ezequiasrocha.blogspot.com/> Are you getting any errors? What have you got set in your pg_hba.conf and postgresql.conf for access rights? Oisin -- Oisin Glynn My status smime.p7s Description: S/MIME C

Re: [SQL] Evaluation of if conditions

Daniel CAUNE wrote: Hi, How does the IF statement evaluate conditions? Does it evaluate conditions following their declaration order from left to right? In case of or-conditions, does the IF statement stop evaluating conditions whenever a first or-condition is true? The following snippet seem

Re: [SQL] how do I check for lower case

Juliann Meyer wrote: I have a table with a column, lets call it identifier, that is defined as varchar(8) that should never contain lower case letters. Its a large table. Is there a way to query the table to see if any values in this column are lower case and to get a list out? The user int

Re: [SQL] Help with performance and explain.

Oisin Glynn wrote: I have an issue with a select returning very slowly approx 198 seconds. I took a backup of this DB and restored it on another system and it is returning in 28 seconds. Windows 2000 PG Version 8.0.3 Data is inserted into the table row by row. Table has index on service

[SQL] Help with performance and explain.

I have an issue with a select returning very slowly approx 198 seconds. I took a backup of this DB and restored it on another system and it is returning in 28 seconds. Windows 2000 PG Version 8.0.3 Data is inserted into the table row by row. Table has index on service explain SELECT callr

Re: [SQL] Concat two fields into one at runtime

George Handin wrote: Is there a way using built-in PostgreSQL functions to combine two data fields into a single field at runtime when querying data? For example, the query now returns: idfirstlast --- --- -- 1 Goerge Handin 2 Joe Rachin I'd like it to re

Re: [SQL] Advanced Query

Richard Broersma Jr wrote: Personally: I think your posts are getting annoying. This isn't SQLCentral. Learn to write your own damn queries or even better - buy a book on SQL... Personally: (being a newbie with an interest in developing a strong rdms skillset) I've enjoyed following threa

Re: [SQL] Am I crazy or is this SQL not possible

Collin Peters wrote: I am having some serious mental block here. Here is the abstract version of my problem. I have a table like this: unique_id (PK) broadcast_id date_sent status 1 1 2005-04-0430 2 1

Re: [SQL] Connecting to Postgres from other machines (outside localhost)

Catalin Pitis wrote: Hello I installed PostgreSQL 8.0 on Windows and I can connect from localhost only. How can I configure the server to allow connection from other machines? Thank you Catalin Under Start-> Programs->PostgreSQLXX->Configuration files postgresql.conf pg_hba.conf Are the

[SQL] Reverse String in sql or pgplsql

Did some searching on forums archives to no avail, I found a  PL/Perl example but would like to do this in plpgsql if possible. Does somebody have this sitting around, I just dont want to reinvent the wheel.  But if need to I will.   Thanks in advance,   Oisin