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
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
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:
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
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,
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 +
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)
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
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
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
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
11 matches
Mail list logo