rawi wrote Just tested with 9.2: pretty much the same -- View this message in context:...

rawi

Yesterday 07:49 AM
rawi

Working on Ubuntu 13.04 64bit (raring) I red, that Pitti-PPA will be discontinued in the future, so we should make the switch to...

rawi

Yesterday 06:31 AM
rawi

Is it valid to specify a SELECT statement as part of a JOIN clause? For example: SELECT table1.f1, table1.f2 FROM table1 INNER JOIN (SELECT...

JORGE MALDONADO

06-14-2013 02:14 AM
Andreas Joseph Krogh

Tom Lane-2 wrote Short or long prefixes seem to be equaly unfavorable. Even with the full length of the words, but queried as prefix I get a runtime...

rawi

06-13-2013 10:39 AM
rawi

Tom Lane-2 wrote Thank you Tom, I'm testing on PG 9.1 on UbuntuServer 12.10, 64bit I'll update to 9.2 the next days and try again. Kind...

rawi

06-13-2013 10:20 AM
rawi

rawi <only4com (AT) web (DOT) de> writes: FWIW, I get fairly decent performance for cases like this in HEAD (at least with a GIN index; GIST seems...

Tom Lane

06-13-2013 09:56 AM
Tom Lane

Hi I tested the following: CREATE TABLE t1 ( id serial NOT NULL, a character varying(125), a_tsvector tsvector, CONSTRAINT t1_pkey PRIMARY KEY (id)

rawi

06-13-2013 06:39 AM
rawi

I need to insert records into a table where one value is fixed and 2 values come from a SELECT query, something like the following example: INSERT...

JORGE MALDONADO

06-07-2013 09:26 AM
Thomas Kellerer

I have a simple table item_number week_of planned_qoh ------------------ ------------------ ------------------ 00005 ...

John Fabiani

06-04-2013 11:24 PM
Jayadevan

I have an update query that I'm not sure if I am taking a good approach or a naive one. It works but seems ugly. I have a table named "contacts". ...

Robert DiFalco

06-02-2013 03:39 PM
Robert DiFalco

Em 29-05-2013 12:51, Vick Khera escreveu: Ok, thanks. I just wanted to be sure there wasn't some hidden feature of PostgreSQL I wasn't aware of...

Rodrigo Rosenfeld Rosas

05-29-2013 11:14 AM
Rodrigo Rosenfeld Rosas

On Wed, May 29, 2013 at 9:58 AM, Rodrigo Rosenfeld Rosas <rr.rosas (AT) gmail (DOT) com The FK tests are basically triggers, but highly...

Vick Khera

05-29-2013 10:51 AM
Vick Khera

Here is a boiled down example of a scenario which I am having a bit of difficulty solving. This is a catchall table where all the rows are related to...

Bill MacArthur

05-29-2013 10:07 AM
Marc Mamin

Sorry, I wasn't sure what list I should be sending this question to... I have a multi-tenant-like application. We have a fields tree that we call a...

Rodrigo Rosenfeld Rosas

05-29-2013 08:58 AM
Rodrigo Rosenfeld Rosas

Hi All, Can any one let me know how much it costs for any professional to teach the following SQL topics in detail for about 1week-10days: SQL...

Prateek Bharadwaj

05-29-2013 01:23 AM
Prateek Bharadwaj

Dear all, I am trying to translate a code written in php to C++. So, I am now using lipq in order to access my postgresql database from C++. As...

Brice André

05-27-2013 02:06 AM
Brice André

I have a query like this: SELECT lpt_titulo AS tmt_titulo, tmd_nombre AS tmt_nombre, tmd_album AS tmt_album SUM(lpt_puntos) AS...

JORGE MALDONADO

05-25-2013 12:52 PM
Marc Mamin

I have one SELECT statement as follows: SELECT lpt_titulo as tmt_titulo, tmd_nombre as tmt_nombre, tmd_album as tmt_album, SUM(lpt_puntos) AS...

JORGE MALDONADO

05-24-2013 01:15 PM
David Johnston

I am running postgresql 9.2. I am assuming it would be a function of psql to right justify text, but I can't find any way to do this. Is there a...

Brian Sherwood

05-18-2013 12:28 AM
Ian Lawrence Barwick

To summarize my question at the top, why is it that when I did the JOIN, the array_agg results reversed order? I had a function that ran the...

George Woodring

05-14-2013 02:38 PM
George Woodring

It hit me today that a 1:n relationship can't be implemented just by a single foreign key constraint if n>0. I must have been sleeping very deeply...

Wolfgang Keller

05-14-2013 01:33 PM
Wolfgang Keller

Hi list, I have some problems with SERIALIZABLE isolation level, namely my users are plagued with concurrency errors. As of postgres 9.1 (which I'm...

Marcin Krawczyk

05-13-2013 05:25 PM
Marcin Krawczyk

I have an UPDATE query which performs several opertions in one table. UPDATE table01 SET field1 = (query1 may contain any field), field2 = (query1...

JORGE MALDONADO

05-06-2013 04:07 AM
Jasen Betts

Hi every one, I'm trying to do the follow: declare aCad text begin

Mauricio Cruz

04-27-2013 01:34 AM
Jasen Betts

Hi, When i tried to delink the old tables i'm getting the following error NOTICE: SELECT COUNT(*) AS count from pg_tables where schemaname='fr'...

shabeer ece

04-23-2013 03:01 AM
shabeer ece

Hi, I am on postgresql 9.1 and use at table like CREATE TABLE timetable( tid INTEGER PRIMARY KEY, gid INTEGER REFERENCES groups(gid), day ...

Wolfgang Meiners

04-22-2013 01:06 PM
Wolfgang Meiners

Hello 2013/4/20 JORGE MALDONADO <jorgemal1960 (AT) gmail (DOT) com> It depends on size of relations - you don't need indexes on small tables...

Pavel Stehule

04-20-2013 11:59 AM
Pavel Stehule

Let´s suppose that I have a SELECT statement that joins more than one table and such a statement is order by fields that belong not only to the...

JORGE MALDONADO

04-20-2013 11:32 AM
JORGE MALDONADO

Hi, I can't change the pass for my user. When I invoke ALTER USER abc PASSWORD newpassword it changes ok but then I can't login with my...

Marcin Krawczyk

04-19-2013 03:13 AM
Marcin Krawczyk

I have a temporary table with columns zone_name, nodeid, nodelabel, nodegainedservice, nodelostservice Zone1, 3, Windows-SRV1,...

chinnaobi

04-18-2013 10:41 PM
chinnaobi

Sofer, Yuval <Yuval_Sofer (AT) bmc (DOT) com> wrote: Use asynchronous mode. There is no way for 'only a little bit synchronized mode'. We are not...

Andreas Kretschmer

04-18-2013 11:38 AM
Andreas Kretschmer

Hi, I am using Postgres DB with stand by database, configured with streaming insynchronized mode (each commit on primary DB waits for commit on...

Sofer, Yuval

04-18-2013 10:41 AM
Sofer, Yuval

Hello, i have try the following: -- Function: wetter.copy_ignore_duplicate(character varying) -- DROP FUNCTION...

basti

04-18-2013 08:48 AM
bricklen

Hello, I'm working on designing a soft-delete scheme for our key entity-- there are 17 other tables that reference our key table via RI. Let's call...

Mark Stosberg

04-18-2013 06:44 AM
Jasen Betts

Hello, I'm trying to put together a fully contained runtime environment and am having trouble with fully qualified path names to dynamic library...

Thomas Burnett

04-16-2013 01:42 PM
Thomas Burnett

SELECT num_ads, sum(...), sum(...), .... FROM ( your query here ) GROUP BY num_ads; BTW, While "SELECT '1' "num_ads" is valid syntax I recommend...

David Johnston

04-13-2013 05:05 PM
Tony Capobianco

Hi, The following when run in PostgreSQL 9.2.x seems to tell that if I have two tables A and B, such that if B inherits A, then, even if I don't...

Robins Tharakan

04-12-2013 04:09 PM
Simon Riggs

Hello, is there any best practice method how to create a foreign key that only allows values from those rows in the referenced table that fulfill an...

Matthias Nagel

04-12-2013 02:52 PM
Richard Broersma

I have a table of artists with fields like the ones below: * Name * Birthday * Sex (male/female) Our application offers a catalog of artists where...

JORGE MALDONADO

04-12-2013 08:29 AM
Jasen Betts

UPDATE tbl SET city=s.city_name FROM shp AS s WHERE ST_CONTAINS(s.city_geom,geom); With the code above i can add exact city to a GPS point. It runs...

androclos

04-11-2013 11:38 AM
androclos

Hi all, * Can someone please point me to detailed documentation on how to secure/encrypt connections between PGBouncer and Postgresql database...

Bhanu Murthy

04-10-2013 01:16 PM
ktm@rice.edu

I am troubled to find out that a SELECT statement produces fewer rows than the actual row count and have not been able to answer myself as to why. I...

Kong Man

04-05-2013 05:51 PM
Kong Man

*Hello Friends, I am new to*Postgres*DB. Recently installed Postgres 9.2.* Facing an issue with very simple trigger, tried to resolve myself by...

Kaleeswaran Velu

04-04-2013 12:54 PM
Kaleeswaran Velu

I'm trying remove all instances of non-alphanumeric or underscore characters from a query result for further use. This is part of a function I'm...

James Sharrett

03-26-2013 07:31 AM
James Sharrett

Hi everyone, I'm working in a PL/SQL and I'd like to use the same PL for 2 kinds of tables... I have "valepag" and "valerec" both tables have...

Mauricio Cruz

03-26-2013 02:08 AM
Pavel Stehule

I need to read from a file in order to update a table. The manual says that it is necessary to have the superuser privilege to read from a...

Jose Antonio Quintana/UPC

03-21-2013 07:40 AM
Adrian Klaver

Hi, I've got a table to import from csv that has an array-column like: import ( id, array_col, ... ) Those arrays look like ( 42, ...

Andreas

03-18-2013 02:43 PM
Andreas

Hi all, I'm composing a query from a web application of type: *SELECT * FROM table WHERE a_text_field LIKE...

Surfing

03-17-2013 05:43 AM
Surfing

Is there a function that will give the resulting zip content for a string? Like SELECT zip('test data');? Thank you.

Victor Sterpu

03-16-2013 07:36 PM
Ben Morrow

dynacom=# SELECT DISTINCT ON (qry.setid) qry.setid, qry.arragg FROM (select distinct sst.setid,(array_agg(vsl.name) OVER (PARTITION BY sst.setid...

Achilleas Mantzios

03-15-2013 01:49 AM
Achilleas Mantzios