Hello, I have a classic parent -> child relation (id, container_id) and I would like to find the full hierarchy for a child, something like A / \ B...

Julien Cigar

08-23-2011 09:39 AM
Julien Cigar

Hi, I'm designing a new database. One of the table contains allowed IP ranges for a customer (Fields: customer_id, from_ip, to_ip) which is intended...

Herouth Maoz

08-23-2011 06:39 AM
Herouth Maoz

Hi I have to rearrange the months according to the fiscal year i.e from April to march and use the same in the order by clause of a query. I have...

Enzen user

08-22-2011 06:58 PM
Gavin Flower

Hi, I am trying to write a function that contains a cursor and iteratively calls itself. It is along the lines of, CREATE FUNCTON test(id integer)...

Kidd, David M

08-18-2011 11:15 AM
Tom Lane

Hi, I have a query hitting a table of 25 million rows. The table has a text field ('identifier') which i need to query for matching rows. The...

adam_pgsql

08-17-2011 03:26 PM
Igor Neyman

Hi everyone, I'm a bit lazy, or actually in a bit of a crunch. I added an audit recording a few months ago, but never really used it much, but...

M. D.

08-16-2011 06:35 PM
Jaime Casanova

Hi, I have a query hitting a table of 25 million rows. The table has a text field ('identifier') which i need to query for matching rows. The...

Adam Witney

08-16-2011 06:14 AM
Adam Witney

Hi, I have the following query: select ticket as ticket, time as created, author as reporter, cast(extract(epoch from (date 'now' - integer...

Janiv Ratson

08-16-2011 04:19 AM
Janiv Ratson

Hi, With MS-SQL sever, there is a built-in utility function dbo.F_TABLE_NUMBER_RANGE which generates a list of number between the given range. For...

Yuan HOng

08-16-2011 12:21 AM
Pavel Stehule

On Saturday, August 13, 2011 12:39:44 pm David Harel wrote: http://www.enterprisedb.com/docs/en/8.4/pgadmin/debugger.html -- Adrian...

Adrian Klaver

08-15-2011 01:53 PM
David Harel

Hi all, This is probably quite simple. I want to calculate the ratio of each country (gwcode) which experiences a 1 in one column...

Andreas Forø Tollefsen

08-15-2011 08:49 AM
Andreas Forø Tollefsen

Hi, Firstly; I'm not a developer, but a business developer and statistics guy. This means that I'm happy using "basic" selects to gather information...

tlund79

08-12-2011 11:03 AM
Oliveiros d'Azevedo Cristina

Hi all, Note: I'm happy to read howtos, tutorials, archived messages - I just haven't found anything that addresses this yet. I found a related...

Don Parris

08-11-2011 04:21 PM
Don Parris

Strange... Tables have hidden columns but AFAIK, "name" is not one of...

Oliveiros d'Azevedo Cristina

08-09-2011 11:04 AM
Tom Lane

Hi! I have strange issue with nested left-joins in postgresql... It's hard to explain, but easy to show =) here we are:

ai

08-08-2011 02:14 PM
Carla

Hi, Can you point me to any pages that explain the difference between using, say CHAR(8) vs VARCHAR(8) as the primary key for a table? Is there...

Raj Mathur

08-05-2011 07:43 AM
Jasen Betts

Hi, Is there any built-in function/add-on module available in PostgreSQL, that converts a given "timestamp"/"timestamptz" value into its relative...

Gnanakumar

08-05-2011 04:07 AM
Gnanakumar

Johann Spies <jspies (AT) sun (DOT) ac.za> wrote: You need to double the backslashes (e. g. "E'\\|{2,}'"); otherwise the parser will "eat" the...

Tim Landscheidt

08-02-2011 11:05 PM
Tim Landscheidt

Hi I see that some queries are not Order(n) where n=number of partitions. However, if one were to run the query separately against...

Mike O'Connel

08-02-2011 03:20 PM
Mike O'Connel

select count(*) from table; count ------- 100 (1 row) is correct

Wes James

08-02-2011 09:13 AM
Wes James

Hi, I just noticed that to_char() will "accept" invalid dates such as 2011-02-31 and "adjust" them accordingly: postgres=> select...

Thomas Kellerer

07-29-2011 12:48 PM
THOMPSON, JARED

I have the following query Select PubArticleId, PubArticlePageXML from PubarticlePageXml x Inner Join Pubarticlepage p on...

Ozer, Pam

07-21-2011 06:28 PM
Ozer, Pam

Hi, in postgreSQL (with LTREE extension) database I have the following table "comments": id BIGINT /* id */ article_id BIGINT /*article-id...

Ivan Polak

07-21-2011 12:31 PM
Ivan Polak

Hi I would like to build Postgres from source with the visual studio 2010 compiler Is it supported? Is there any document which describes the...

Sofer, Yuval

07-20-2011 09:39 AM
Kevin Crain

Hello, I've been trying to find out how to find out which sql was run to create a certain table. As I need this in a program which may access...

B.Rathmann

07-14-2011 06:40 PM
Craig Ringer

----- Original Message ----- From: LALIT KUMAR To: Oliveiros d'Azevedo Cristina Hi, I do have order of rows. The problem originally is: I...

Oliveiros d'Azevedo Cristina

07-14-2011 06:30 AM
Oliveiros d'Azevedo Cristina

Hi, I'm using postgresql 9 and I'd like to know if there is a way to "ask" if when I'm going to add a column, I'm exceeding the max number of...

Miguel Angel Conte

07-13-2011 01:20 PM
Kevin Crain

I'm using Erlang and postgresql to build a web interface. When I create the query string I get something like: select * from table where...

Wes James

07-13-2011 10:36 AM
Wes James

On Wed, Jul 13, 2011 at 03:27:10PM +0200, Jira, Marcel wrote: You may want to take a look at pl/R which make the R system available to PostgreSQL as...

ktm@rice.edu

07-13-2011 08:58 AM
ktm@rice.edu

Hi! Let's consider I have a table like this id qualification gender age income I'd like to select (for example 100) lines of this...

Jira, Marcel

07-13-2011 08:27 AM
Jira, Marcel

Jose Ig Mendez, 13.07.2011 09:36: Just leave out the quotes: select * from myTable where id_integer IN (1,2,3,4) --

Thomas Kellerer

07-13-2011 02:50 AM
Pavel Stehule

Hi, I'm starting up a datawarehouse with patitioning. my etl processes write directly into the corresponding partitions instead of using...

Uwe Bartels

07-10-2011 05:48 PM
Gavin Flower

hi all, can you tell me what is similar to like operator in mysql for postgresql hatem gamal -- Sent via pgsql-sql mailing list (pgsql-sql (AT)...

hatem gamal elzanaty

07-10-2011 04:11 PM
Scott Marlowe

Good morning, A question about: ERROR: malformed record literal: "" DETAIL: Missing left parenthesis. Can someone tell me what cause the...

Emi Lu

07-06-2011 10:53 AM
Emi Lu

This is a little hard to explain, and I'm not sure if it's possible, but here goes. This is my query: select year, month, (select number from...

M. D.

07-06-2011 02:04 AM
Samuel Gendler

Hi I have a stored function returning a record consisting of two field, and receiving as input a single identifier: CREATE FUNCTION calcvalues(IN...

gmb

07-05-2011 04:07 AM
gmb

Hi, how can I remove a set of characters in text-columns ? Say I'd like to remove { } ( ) ' " , ; . : ! Of course I can chain replace ( replace (...

Andreas

06-30-2011 09:43 PM
Andreas

what is the best performance / best practices for frequently-used simple dml, for example, an insert 1. fast-interface 2. prepared statement calling...

chester c young

06-27-2011 08:40 AM
Pavel Stehule

Hi, I have a SELECT statement that is using the regexp_split_to_table function as follows: .... and fk_topic in (select...

John Fabiani

06-23-2011 11:45 AM
John Fabiani

the database collation is: en_US.UTF-8 drop table t1; create table t1 (recid int ,f1 varchar(20)); insert into t1 values (1,'a'); insert into t1...

Eyal Wilde

06-23-2011 02:18 AM
Pavel Stehule

Hi, I've got a table with a couple of objects. Primary key object_id. There is a function that fetches some values from another table that relate...

Andreas

06-20-2011 10:56 PM
Pavel Stehule

Hi, I am totally new to PostgreSQL and this is my first script. Can anyone please help me with my following requirement I have script that returns ...

Tripura

06-20-2011 12:05 PM
Ross J. Reedstrom

I am trying to select nested commentes from a table with this structure CREATE TABLE picture_comments ( comment_id serial NOT NULL, user_id integer...

Cstdenis

06-20-2011 10:04 AM
Cstdenis

hi, please see this code select aiah_number.aiah_number_id, aiah_number.aiah_number, lock.lock_status, rank.rank_value, approve.approve_status,...

hatem gamal elzanaty

06-20-2011 08:29 AM
Emi Lu

Hi, I am new to postgre sql.I need to convert sqlite datbase to postgres database.i have nearly 15 table in my sqlite database in which 3 table...

sara vanan

06-16-2011 05:08 PM
Viktor Bojović

On 06/15/2011 10:59 PM, Tom Lane wrote: Thanks for the research. I was indeed reading from SQL99, which was current the last time I used SQL. I'll...

Clem Dickey

06-16-2011 02:07 PM
Clem Dickey

Clem Dickey <dickeycl (AT) us (DOT) ibm.com> writes: Hmm ... I think you are looking at SQL92 or SQL99. The later versions of the spec don't seem...

Tom Lane

06-16-2011 12:59 AM
Tom Lane

I have a fact table that looks like this: dim1_fk bigint, time_fk bigint, tstamp timestamp without timezone value numeric(16,2) The tstamp column...

Samuel Gendler

06-15-2011 03:52 PM
Samuel Gendler

Hi! Although I try for some time, I am not able to write an SQL-Query that can do the following: I have a very big table (let's call it "mytable")...

Jira, Marcel

06-15-2011 11:49 AM
Oliveiros d'Azevedo Cristina

Hi Everybody ! I'm just wondering what is really better in terms of performance ... I have a large function that makes many things, and I must...

Charles N. Charotti

06-15-2011 10:40 AM
Charles N. Charotti