Re: [GENERAL] Locale Issue

2013-08-23 Thread Vincent Veyron
Le jeudi 22 août 2013 à 20:06 -0400, Don Parris a écrit : > locale showed everything *except* LC_ALL as being en_US.UTF-8. > LC_ALL was empty. I can only guess that the LC_ALL setting may have > played a part in the problem. I doubt it, mine was not set either and the installation went fine. Se

[GENERAL] numeric to ipv6 inet

2013-08-23 Thread Mikhail Puzanov
Hello, I need to convert the set of ipv6 addresses stored as numerics (by historical reasons mostly) to inet type. Something like '0:0:0:0:0:0:0:0'::inet + 55831599345971591062080247067748335616::bigint apparently doesn't work as the number added is too big to be converted to bigint. Is there an

Re: [GENERAL] filling database

2013-08-23 Thread sachin kotwal
create sample table with one or two rows then use following command to populate data. INSERT INTO TABLE_NAME VALUES(generate_series(1,10)); - Thanks and Regards, Sachin Kotwal NTT-DATA-OSS Center (Pune) -- View this message in context: http://postgresql.1045698.n5.nabble.com/GENE

Re: [GENERAL] numeric to ipv6 inet

2013-08-23 Thread Osvaldo Kussama
2013/8/23, Mikhail Puzanov : > Hello, > > I need to convert the set of ipv6 addresses stored as numerics > (by historical reasons mostly) to inet type. > > Something like > '0:0:0:0:0:0:0:0'::inet + 55831599345971591062080247067748335616::bigint > apparently doesn't work as the number added is too

Re: [GENERAL] Column names for INSERT with query

2013-08-23 Thread David Johnston
Robert James wrote > I would like to: > > INSERT INTO t > SELECT * FROM r, (x + y) AS field3 > > How do I correlate the names of the fields? That is, how do I indicate > which fields from r or field3 should be inserted into the right > columns in t? Already answered but I'll add that as written,

[GENERAL] Update quey

2013-08-23 Thread Hall, Samuel L (Sam)
I have a table (pubacc_lo) from the US government with 500,00+ rows. It has latitude and longitude in three columns each for degrees, minutes and seconds. I need a Point geometry column. So I wrote this query: with mydata AS (SELECT (pubacc_lo.lat_degrees + pubacc_lo.lat_minutes/60 + pubacc_lo.

Re: [GENERAL] Update quey

2013-08-23 Thread Hall, Samuel L (Sam)
Thank you! That worked fine. From: bricklen [mailto:brick...@gmail.com] Sent: Friday, August 23, 2013 10:08 AM To: Hall, Samuel L (Sam) Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Update quey On Fri, Aug 23, 2013 at 8:04 AM, Hall, Samuel L (Sam) mailto:sam.h...@alcatel-lucent.com>>

Re: [GENERAL] Update quey

2013-08-23 Thread bricklen
On Fri, Aug 23, 2013 at 8:04 AM, Hall, Samuel L (Sam) < sam.h...@alcatel-lucent.com> wrote: > I have a table (pubacc_lo) from the US government with 500,00+ rows. It > has latitude and longitude in three columns each for degrees, minutes and > seconds. I need a Point geometry column. So I wrote th

[GENERAL] performant import of an array

2013-08-23 Thread Janek Sendrowski
Hi, I have an array and I want to import the data rowwise. Would it make sense to use a function which calls a prepared statement in a loop to import the data performant? Or can I somehow use the COPY FROM command?   Janek Sendrowski -- Sent via pgsql-general mailing list (pgsql-general@post

Re: [GENERAL] performant import of an array

2013-08-23 Thread Pavel Stehule
Hello import data to auxiliary table, and then use a ARRAY(subselect) or array_agg function to transformation from table to array. Regards Pavel 2013/8/23 Janek Sendrowski > Hi, > > I have an array and I want to import the data rowwise. > > Would it make sense to use a function which calls a

Re: [GENERAL] numeric to ipv6 inet

2013-08-23 Thread Arjen Nienhuis
On Aug 23, 2013 11:58 AM, "Mikhail Puzanov" wrote: > > Hello, > > I need to convert the set of ipv6 addresses stored as numerics > (by historical reasons mostly) to inet type. > > Something like > '0:0:0:0:0:0:0:0'::inet + 55831599345971591062080247067748335616::bigint > apparently doesn't work as