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. See

[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

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:

Re: [GENERAL] numeric to ipv6 inet

2013-08-23 Thread Osvaldo Kussama
2013/8/23, Mikhail Puzanov misha.puza...@gmail.com: 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

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 +

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)

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 this

[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

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 jane...@web.de Hi, I have an array and I want to import the data rowwise. Would it make sense to use a function

Re: [GENERAL] numeric to ipv6 inet

2013-08-23 Thread Arjen Nienhuis
On Aug 23, 2013 11:58 AM, Mikhail Puzanov misha.puza...@gmail.com 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