Re: [SQL] Enc: Help to replace caracter

On Friday 14 Nov 2008, paulo matadr wrote: > I Need to replace string (" ) in the situation below : > > select clie_nmclientefrom cadastro.cliente where clie_nmcliente > like '%"%'; > > result: > JOANA D"ARCALMEIDA" > EMLURB "P M R." > CECILIA D"CAGNO" > HELENA FERREIRA D"FREITAS" > JOSE M. "B

[SQL] Query to match location transitions

Hi, I was hoping someone could help me build a better query. I have a table of time/locations. Occasionally, we have multiple timestamps for the same location. I would like to remove those extra timestamps and only show the transition from one location to another. So... create table time_loca

[SQL] raise doesn't add end of line

Hi there, I upgrade "PostgreSQL 8.2.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)" to "PostgreSQL 8.3.5, compiled by Visual C++ build 1400", and I found that many RAISE statements in a function no more adds end of line (CR/LF) on every message. Just when the funcion

[SQL] Enc: Help to replace caracter

I Need to replace string (" ) in the situation below : select clie_nmclientefrom cadastro.cliente where clie_nmcliente like '%"%'; result: JOANA D"ARCALMEIDA" EMLURB "P M R." CECILIA D"CAGNO" HELENA FERREIRA D"FREITAS" JOSE M. "BARRACA DO BOLA" FORTE" DUNAS BAR" JOANA D"ARC R. DE SO

Re: [SQL] uuid on windows

> > I *think* it's one of the optional modules with recent installers, but I > don't run Windows routinely, so you'll have to check. > I installed with full optional modules on Windows, but uuid is still missing. However, I found C:\Program Files\PostgreSQL\8.3\share\contrib\uuid-ossp.sql, I run

Re: [SQL] trapping a NULL querystring error

am Fri, dem 14.11.2008, um 7:29:32 -0300 mailte Gerardo Herzig folgendes: > Hi all. Inside a plpgsql function, i have a EXECUTE statement, which > sometimes seems to be receiving a null querystring. > > Can i check that condition in a BEGIN..EXCEPTION block? Under which > condition? > > Or shou

[SQL] trapping a NULL querystring error

Hi all. Inside a plpgsql function, i have a EXECUTE statement, which sometimes seems to be receiving a null querystring. Can i check that condition in a BEGIN..EXCEPTION block? Under which condition? Or should just check if that string is null? Thanks! Gerardo -- Sent via pgsql-sql mailing li

Re: [SQL] uuid on windows

Sabin Coanda wrote: > I run the following script and now it works: > > CREATE OR REPLACE FUNCTION uuid_generate_v1() > RETURNS uuid > AS '$libdir/uuid-ossp', 'uuid_generate_v1' > VOLATILE STRICT LANGUAGE C; > > Similar for all the other defined uuid functions. There should be a uuid-ossp.sql fil

Re: [SQL] uuid on windows

I run the following script and now it works: CREATE OR REPLACE FUNCTION uuid_generate_v1() RETURNS uuid AS '$libdir/uuid-ossp', 'uuid_generate_v1' VOLATILE STRICT LANGUAGE C; Similar for all the other defined uuid functions. Unfortunatelly I experienced the same problem on linux version 8.3.5. a

Re: [SQL] uuid on windows

Sabin Coanda wrote: > Hi there, > > I installed Postgres "PostgreSQL 8.3.5, compiled by Visual C++ build 1400" > on Windows OS, and I tried to check some uuid functions, for instance: > SELECT uuid_generate_v1(); > > But I found the following error message: > ERROR: function uuid_ge

[SQL] uuid on windows

Hi there, I installed Postgres "PostgreSQL 8.3.5, compiled by Visual C++ build 1400" on Windows OS, and I tried to check some uuid functions, for instance: SELECT uuid_generate_v1(); But I found the following error message: ERROR: function uuid_generate_v1() does not exist LINE