Hello, I have some problems using character class matching (e.g. ).. For example I have a table: CREATE TABLE re_test (text_column character...

Eduardas Kazakas

09-29-2010 08:30 AM
Osvaldo Kussama

I loaded data from a spread into a interim table so I can analyze the quality of the data. The table contains an entry for every student (250K...

Tarlika Elisabeth Schmitz

09-29-2010 08:00 AM
Oliveiros d'Azevedo Cristina

Dear List, I have created a database with the template postgis. In this database a shema named ‘public’ was created, with the functions...

Thomas Andres

09-29-2010 01:42 AM
Thomas Andres

Hi, is there a distinct function for comma separated lists ? I sometimes need to update tables where I got a set of IDs, like: update mytable set...

Andreas

09-28-2010 09:00 AM
msi77

hi, i am trying to dump a table with insert command rather tahn copy. pg_dump -Dt --insert table dbname > table.sql; i am not able to get the...

Nicholas I

09-27-2010 06:31 AM
Vibhor Kumar

Hi, the data in my table, have a substring enclosed in parenthesis, 1. i want to replace the string with the brackets to null or any...

Nicholas I

09-24-2010 09:39 AM
Leif Biberg Kristensen

Hi, i have two tables, --------------------------------------------------------------- *table1 id type serial, name...

Nicholas I

09-24-2010 04:37 AM
James Kitambara

A local installation of 9.0 does not seem to include pg_config. (not with pg_dump pg_ctl etc, no man page) This is a Suse box (openSUSE 11.2...

Rob Sargent

09-23-2010 01:46 PM
Rob Sargent

9.0 allows you to defer unique constraints. Ken On Thu, Sep 23, 2010 at 10:18:39AM -0700, Ozer, Pam wrote: -- Sent via pgsql-sql mailing list...

Kenneth Marshall

09-23-2010 01:33 PM
Kenneth Marshall

Gary, Based on what I read it wouldn't handle cases where the result should be MacDonald from macdonald. There are other cases such as the...

Michael Gould

09-23-2010 09:13 AM
Jonathan Brinkman

Hi, how could I divide streetnames from housenumbers ? I have to deal with input like this: Parkstreet 42 Parkstr. 42 Casle Avenue 42 Casle Str....

Andreas

09-23-2010 05:53 AM
Andreas Schmitz

hi: I have a fairly large table. sample_id | chr | cfrom | cto | ------------------------------------------- 1 c2 19 20 2 ...

Adrian Johnson

09-23-2010 05:01 AM
Oliveiros d'Azevedo Cristina

Dear group, I just started learning postgres and I have to analyze my data. So please bear with me, for all the simple questions that I am...

Adrian Johnson

09-21-2010 06:16 PM
Adrian Johnson

Is it possible to just download the RPM package for postgresql server 8.4 for fedora and NOT install it through the yum tree? If so where can I go...

Joshua Gooding

09-21-2010 03:22 PM
Devrim GÜNDÜZ

Hi list, this is a Friday afternoon question... :) I have a table like this: id_user | value | datetime 1 | 1 | xxx 1 | 2 | xxx+1 1 | -1 | xxx+2 2 |...

Michele Petrazzo - Unipex

09-21-2010 10:02 AM
Oliveiros d'Azevedo Cristina

Hi folks,I have a view that seems to be very slow compared to similar views on the same server. I've had a look at running explain but I don't...

Gary Stainburn

09-21-2010 09:52 AM
Tom Lane

It seems that PostgreSQL 8.4 does not support ragged arrays. Is there a workaround to get similar functionality (mainly the ability to extract...

Florian Weimer

09-21-2010 02:19 AM
Dmitriy Igrishin

Hi, I have a question which does not seem to be covered in the documentation: I have a function f(i) that returns a table with three columns (a, b,...

Jann Röder

09-20-2010 02:43 AM
Jann Röder

Forget my previous post. I am stupid. It doesn't work with 8.3.7, sorry to trouble you. -- Greg Quinn Australian Phenomics Facility greg.quinn...

Greg Quinn

09-16-2010 12:45 AM
Greg Quinn

Hullo. I've been a Postgresql user for many years, so forgive me if I'm doing something really stupid. I cannot get 'with' queries to work at all....

Greg Quinn

09-16-2010 12:05 AM
Greg Quinn

Finally i'm using: EXECUTE 'CREATE USER '|| quote_ident(creds."userName") ||' WITH PASSWORD '|| quote_literal(creds."userPassword") || ' IN GROUP...

Tatarnikov Alexander

09-15-2010 09:03 PM
Tatarnikov Alexander

That's too "generic". I was answering specific question. Now, yes, dynamic sql could be used for SQL injection, if not used carefully. But, it...

Igor Neyman

09-15-2010 02:08 PM
Igor Neyman

Hello! I have function wich check user credentials and if test passed function must create new user with generated username and password. Language...

Tatarnikov Alexander

09-15-2010 01:28 PM
Asko Oja

Hello list, I don't know if it's me, or maybe even the way I designed these dependencies, but I'm getting unexpected results when i query a...

Nathan Grange

09-14-2010 12:51 PM
Tom Lane

Hello List, I have a small question about the order of values in a query. Assume I have a table with the following fields: uid INT, data...

Steve

09-14-2010 06:31 AM
Frank Bax

delete from form_record_details where form_record_id in (select form_record_id from forms where form_id= 40003656) Seems fine at 1am. However the...

Greg Caulton

09-10-2010 05:07 AM
Thomas Kellerer

Hello, According to the documentation, I thought it was possible to force given join orders with parenthesis. But in this small example, this seems...

Marc Mamin

09-09-2010 08:49 AM
Tom Lane

Hi List, I'm kinda stuck situation, I have a timestamp which resambles a startdate and a duration in days and I want to bloat this, so I have a row...

Tim Schumacher

09-08-2010 11:02 AM
Joe Conway

On psql 8.3.9, I ran a limited query limited to 5 results. There was a moderately expensive function call which I expected to be called 5 times, but...

Bryce Nesbitt

09-07-2010 03:31 PM
Tom Lane

Hi, I am trying to name arguments in aggregate function, but i don't know how, so im asking if someone can help me to solve this. Im working with...

Viktor Bojović

09-05-2010 07:35 PM
Tom Lane

looking for something like SELECT SUM (cost) from ( (SELECT i.id_item, i.price, SUM (o.quantity), ROUND (SUM (o.quantity) * i.price, 2) AS cost FROM...

Jayadevan M

09-02-2010 07:28 AM
Jayadevan M

Hi, I don't see any overlap between the polygon and the box in the following sql. Can anyone explain why it returns 't'? select polygon(path...

Gary Fu

09-01-2010 08:42 AM
Tom Lane

Hi All, I am using PostGRES 8.3 in conjunction with ESRI's ArcSDE. ArcSDE allows the storage of spatial data inside of an PostGRES database. One of...

Michael Andrew Babb

08-31-2010 07:58 PM
Michael Andrew Babb

Hi. Well... As far as I can see, for functions you should go to the 'pg_catalog' schema, table 'pg_proc'. In column 'prosrc' you will find the...

Hélder M. Vieira

08-30-2010 01:30 PM
Reinoud van Leeuwen

Hi, In general what are the causes of SQL select statement slow downs - other than the size of the data? I realize this is a broad question but read...

John Fabiani

08-28-2010 11:11 AM
John Fabiani

Hey all, As is known, there are many valid literal values for the "true" and "false" state of boolean data type. True whether that output of boolean...

Dmitriy Igrishin

08-26-2010 09:22 AM
Dmitriy Igrishin

Hi, I have some sql like so: SELECT min(date) INTO d FROM interest_rate WHERE m_code = NEW.code; UPDATE interest_rate SET date = NEW.start_date,...

Ben Carbery

08-25-2010 09:46 AM
Bruce Momjian

I have two tables: A: ItemID (PK), IsssueID (Indexed) B: ItemID (FK), IndexNumber : PK(ItemID, IndexNumber) Both tables have several million...

Jann Röder

08-22-2010 11:05 PM
Jann Röder

I have a CMS with a table of items, and another table serving as a log of operations performed on the items. The revelent table structure is as...

Gordon McVey

08-19-2010 08:24 AM
Oliveiros d'Azevedo Cristina

Hi! My question is, how can I get the out parameter from a function with SELECT INTO by name? I mean: create function testfunc1(OUT _status...

Imre Horvath

08-18-2010 05:18 PM
Sergey Konoplev

Hello. I have a database query I am trying to develop. For the purpose of explanation, I am going to use a suit of playing cards in ascending order...

Mindtonic

08-18-2010 04:51 PM
Mindtonic

On Tue, Aug 17, 2010 at 8:21 PM, Jose Ildefonso Camargo Tolosa <ildefonso.camargo (AT) gmail (DOT) com> wrote: Yes it can index such things, but it...

Scott Marlowe

08-18-2010 12:51 AM
Sergey Konoplev

Hi! I'm analyzing the possibility of using PostgreSQL to store a huge amount of data (around 1000M records, or so....), and these, even though are...

Jose Ildefonso Camargo Tolosa

08-17-2010 09:30 PM
Jose Ildefonso Camargo Tolosa

Hi all, I'm working on porting an old MS Access form application from Sybase to postgres/ODBC as part of a larger database port project. One of the...

Peter Koczan

08-17-2010 04:06 PM
Peter Koczan

Hi! My question is, how can I get the out parameter from a function with SELECT INTO by name? I mean: create function testfunc1(OUT _status...

Horváth Imre

08-17-2010 01:45 PM
Horváth Imre

Could someone provide a link or help me understand what is required to get function debugging working. I haven't started yet and I thought it best...

John Fabiani

08-16-2010 09:52 AM
John Fabiani

Greetings! First: This is working, I just need a clarification on concept, so, it is not necessary for you to look deeply at the SQL statement. I...

Jose Ildefonso Camargo Tolosa

08-11-2010 06:56 PM
Jose Ildefonso Camargo Tolosa

Is there any way to remove a duplicate row from a table? Not my db but I have to work with it. On version 7.4 right now. Edward W....

Edward W. Rouse

08-10-2010 11:50 PM
A. Kretschmer

Hi! I don't know if it's the right place or the psycopg2 list: I've got a plpython function, with a character varying param. I can call it from...

Imre Horvath

08-10-2010 12:42 PM
Tom Lane

Hey all, Is it guaranteed that functions, which accept PGconn* properly works if PGconn* is NULL (or just 0) and returns in such cases the same...

Dmitriy Igrishin

08-10-2010 08:35 AM
Dmitriy Igrishin