given a simply table table like this: create table MyTabl (id serial, lname varchar, primary key (id) ) I am trying to return the Primary-Key for a...

Stefan Becker

11-30-2010 08:16 AM
Florian Weimer

Hi, I am using postgres 8.4 and I am having problems doing a very simple query: select zona_id from zonas where zona_id not in (select zona_id from...

Jorge Arenas

11-30-2010 07:22 AM
Carla

i am trying to run a query but its not working may be due to constraint conflicts i have table A, B and C B and C have a foreign key linked with A's...

manidegr8

11-30-2010 04:00 AM
manidegr8

Hi, All I'm trying to make a kind of upsert for the following table: CREATE TABLE sequences ( section VARCHAR( 50 ) NOT NULL, name VARCHAR( 50 )...

Mikhail V. Puzanov

11-27-2010 09:08 AM
Mikhail V. Puzanov

Hello to all, I have a question regarding the behavior of insert row in the two versions, tried to search for it but could not find a similar case,...

ndias

11-26-2010 11:28 AM
ndias

Hi list, Into a table like this: id_user | my_date and some data inside 1 | 2010/11/25 00:01:00 1 | 2010/11/25 00:02:00 1 | 2010/11/25 01:01:00 2 |...

Michele Petrazzo - Unipex

11-26-2010 10:07 AM
Lew

Hi, I'm just beggining in PostgreSql 9.0 I've created a table ,like this: CREATE TABLE auxiliar ( ano integer, codigodc character varying, id...

Ana Louro

11-26-2010 01:45 AM
Pavel Stehule

Hi, I have a strange issue that is mostly likely me not understanding something. I always thought that an insert statement would accept any select...

John Fabiani

11-25-2010 09:22 AM
Trinath Somanchi

Hi, On time series price data I'm trying to remove consecutive identical prices and keep only the latest. I tried: delete from price where id_price...

Louis-David Mitterrand

11-24-2010 02:53 PM
Louis-David Mitterrand

Hi, is there an elegant way to tell PG : a) Hey PG, look here are e.g. 3 values A, B, c for tableX b) please check if there is a row matching ...

Andreas

11-22-2010 10:11 PM
tv@fuzzy.cz

MESH Data Tree: example: Hallux;A01.378.610.250.300.792.380 where: A01 is Body Regions A01.378 is Extremities A01.378.610 is Lower...

Ferruccio Zamuner

11-21-2010 05:50 AM
Dmitriy Igrishin

Hello, Is there a way to force the view column change from varhcar(32) to varchar(128)? Example: =================== v1 (id varchar(32) ......

Emi Lu

11-19-2010 11:34 AM
Richard Broersma

Hi, I was wondering if it is possible to do this with a single query rather than iterate over all of the rows in an application: I have a table...

John Lister

11-18-2010 04:09 AM
Oliveiros d'Azevedo Cristina

John Lister <john.lister-ps (AT) kickstone (DOT) com> wrote: Sure, as Tom Lane pointed out, with >= 8.4: test=*# select * from offers ; id |...

Andreas Kretschmer

11-17-2010 10:02 AM
Andreas Kretschmer

Hi all, For each event of each type in each interval I want to compute the sum of events referencing the same relayNet (via host) and...

Axel Rau

11-16-2010 10:29 AM
Axel Rau

Hi, I frequently get tables from spreadsheets to import into the DB. Usually it looks like this: A1, A2, A3, A4, B1, B2, B3, with optional C1,...

Andreas

11-16-2010 02:21 AM
Jasen Betts

Hi, I'm creating the function on a postgres 8.2 server. I would like the function to accept half a dozen varied parameters (varchars and...

berelith

11-14-2010 12:41 PM
Pavel Stehule

The following command works fine when pasing it to psql via the -c option: cat event.csv | \ psql -c "COPY (event_id, event_name) FROM STDIN...

Tarlika Elisabeth Schmitz

11-13-2010 09:04 AM
Tarlika Elisabeth Schmitz

I have the following problem: Create temp table ranges (Groups int, ColumnA int); Insert into ranges Values(2,45);

Ozer, Pam

11-12-2010 10:36 AM
Ozer, Pam

On Wed, Nov 10, 2010 at 12:28:46PM -0800, Bryce Nesbitt wrote: You could try...

Joshua Tolley

11-12-2010 09:50 AM
Joshua Tolley

I have a cluster with log_min_duration_statement set to log slow queries. Presently what I'm tracking down is almost certainly a lock problem. Is...

Bryce Nesbitt

11-12-2010 03:35 AM
Gunnlaugur Briem

Hi, I've got an PG 8.4 on a opensuse box running. The DB is unicode german. There is a text column I'd like to order by but as far as I see...

Andreas

11-09-2010 10:10 AM
Tom Lane

Hi, I occasionally see lock-wait log messages about SELECT queries waiting for AccessShareLock on a table for a while, 15-20 seconds. So...

Gunnlaugur Briem

11-08-2010 02:44 PM
Gunnlaugur Briem

Got around the problem by learning pg/plsql and writing a non-recursive breadth-first graph traversal function. It maintains an array of...

Will Furnass

11-07-2010 04:18 AM
Will Furnass

I'm also stuck on 7.4 for at least a few more months, but that's not part of the problem. I've spent hours on this, cutting things out, etc., now I...

Ralph Smith

11-04-2010 02:07 PM
Ralph Smith

I'm sure this has been asked before, but I couldn't find it: I have a "zzz CHAR (8)" field. It needs to be CHAR because trailing spaces need to be...

Dean Gibson

11-04-2010 01:47 PM
Kenneth Marshall

Hi, i'm trying to reorganize a big table without having a downtime at all. I'm trying to realize this via partitioning and rules. - step 1...

Uwe Bartels

11-02-2010 01:54 AM
Uwe Bartels

Am 01.11.2010 13:15, schrieb Brian Sherwood: This was the easy part. Suppose those lines above were the input table "interfaces" and the columns...

Andreas

11-01-2010 06:23 PM
Andreas

Hi, i have very big XML documment which is larger than 50GB and want to import it into databse, and transform it to relational schema. When splitting...

Viktor Bojović

10-31-2010 05:07 PM
Rob Sargent

I've a third-party app which is slower than it ought to be. It does one operation in particular by doing a query to get a list of rows, and then...

James Cloos

10-31-2010 08:10 AM
Tom Lane

Yeah, it's an unimplemented feature --- there's no hashing support for arrays. I hope to get that done for 8.5. In the meantime you have to use...

Will Furnass

10-29-2010 02:31 PM
Will Furnass

Good morning, I have a function argument blah of type text containing something like 33,44,55,66 .. Can I cast it in some way to use it in an IN...

Axel Rau

10-29-2010 12:11 PM
Dmitriy Igrishin

Dear All, I want to convert integer datatype to serial datatype.. is that possible.Please let me know. Thanks and Regards, Ven

venkat

10-29-2010 12:00 AM
Shoaib Mir

Dear Alban, Thanks for your great response.I am not able to compile the query which you have given..I am not able to understand.Please alter my...

venkat

10-26-2010 04:27 AM
Dann Corbit

Dear All, I want to update multiple row in single query.I am trying for below query.I am getting error as "ERROR: more than one row returned by a...

venkat

10-26-2010 02:07 AM
venkat

Thanks Richard and Sergey, your solution works perfect, even if blah contains only one member. Am 25.10.2010 um 18:17 schrieb Richard...

Axel Rau

10-25-2010 02:01 PM
Axel Rau

Good morning, I have a function argument blah of type text containing something like 33,44,55,66 .. Can I cast it in some way to use it in an IN...

Axel Rau

10-25-2010 11:17 AM
Sergey Konoplev

Hi, I'm wondering if there was a clever way to find parts of a numeric string in another table. There is a table that holds city-codes and...

Andreas

10-25-2010 08:13 AM
Harald Fuchs

have any one idea !!! postgres db, to insert record in a table of other database through function!!! u see the dblink , but it just use for select...

Maruti Nandan

10-24-2010 07:52 AM
Osvaldo Kussama

Hi, is it possible to insert into a table from list or an array ? Suppose there is a set of numbers that might be IDs of tables within the DB. To...

Andreas

10-18-2010 06:05 PM
Andreas

Hi guys, I use the following code to detect alphanumeric strings: IF _my_variable SIMILAR TO '^+$' THEN * * * * // do stuff here END IF; In pg8.4...

Rommel the iCeMAn

10-16-2010 11:23 AM
Rommel the iCeMAn

Hi, how can I collect text-fields from multiple rows into one output row? I'd like to do an equivalent to the aggregate function SUM() only for...

Andreas

10-16-2010 02:23 AM
Thomas Kellerer

I have a table which includes a text column containing posix-style paths. Ie, matching the regexp "^+(/+)*$". I need to do a query of a number of...

James Cloos

10-15-2010 04:57 AM
James Cloos

All, I've been provided a CSV file of parts that contains duplicates of properties (e.g. resistors have a wattage, tolerance, and...

Gary Chambers

10-12-2010 10:14 AM
Rob Sargent

Hi, Is there a conditional string-concatenation ? I'd like to have an elegant way to connect 2 strings with some 3rd element between only if there...

Andreas

10-12-2010 04:01 AM
Pavel Stehule

Hi, while parsing this type of XML: <entry version="21" modified="2009-07-07" dataset="S" created="2009-06-16"> <accession>Q91G55</accession> i...

Viktor Bojović

10-12-2010 02:10 AM
Viktor Bojović

Hi. I am trying to create a datefield using YEAR, MONTH and DAY fields of type integer. I tried this query, but it did not give good results: select...

Andreas Forø Tollefsen

10-06-2010 06:43 AM
Andreas Forø Tollefsen

When I join tables; I will sometimes get multiple rows back as in this example. create table class(name varchar, p point, d int); insert into class...

Frank Bax

10-04-2010 08:24 AM
Joshua Tolley

Hi, I need to insert a lot of basically blank records into a table to be filled later. Sounds silly but please bear with me. :) projects (...

Andreas

10-03-2010 09:46 PM
Scott Marlowe

I have the following query Select Distinct VehicleMake, VehicleModel From VehicleYearMakeModelTrim Order by random()

Ozer, Pam

10-02-2010 08:52 AM
Tom Lane