Hi,
I am looking for a feature that would select from a table with
k1 a
k1 b
k1 c
k2 a
k3 b
k3 c
something like
k1 a b c
k2 a
k3 b c
(Just all elements next to each other, with a space in between)
or perhaps an array output
k1 {a,b,c]
k2 {a}
k3 {b,c}
If such an operator exists,
On Sat, Apr 14, 2012 at 1:22 AM, haman...@t-online.de wrote:
Hi,
I am looking for a feature that would select from a table with
k1 a
k1 b
k1 c
k2 a
k3 b
k3 c
something like
k1 a b c
k2 a
k3 b c
(Just all elements next to each other, with a space in between)
or perhaps an
On Sat, Apr 14, 2012 at 1:28 AM, Abel Abraham Camarillo Ojeda
acam...@the00z.org wrote:
On Sat, Apr 14, 2012 at 1:22 AM, haman...@t-online.de wrote:
Hi,
I am looking for a feature that would select from a table with
k1 a
k1 b
k1 c
k2 a
k3 b
k3 c
something like
k1 a b c
k2 a
haman...@t-online.de writes:
Tom Lane wrote:
If you want it to be bulletproof, what I'd think about is something like
WHERE second.path LIKE quote_like(first.path)||'%'
Just out of curiosity: wouldn't that (as well as using non-static like)
be an enormous performance problem?
Hi,
I am looking for a feature that would select from a table with
If such an operator exists, would there be a remove duplicates option?
Regards
Wolfgang Hamann
select k, array_agg(distinct val ) from t;
See the docs:
well, I have kept searching for it and found a somewhat funny message
from the sraoss.co.jp guys
[GENERAL] LPI-Japan to start PostgreSQL certfication
and a long thread
[GENERAL] PostgreSQL Certification
which tellingly was quickly hijacked into other topics
on pearsonvue.com/sra/ it
On 13 Apr 2012, at 18:43, Jeff Adams wrote:
Thanks for the ideas Steve. I am actually working with a partitioned table
and the field I am modifying is the id field (I have reached the cap on the
integer data type and need to modify it to bigint - very poor planning on my
part!), but no
Em 12 de abril de 2012 14:12, Phoenix Kiula phoenix.ki...@gmail.comescreveu:
I had pgbouncer working somehow, but we have switched servers recently
and now I cannot for the life of me figure out again how to set it up.
Online guides say things like create a user ID. Well, where? Inside
PG
On Sat, Apr 14, 2012 at 4:31 PM, Clodoaldo Neto
clodoaldo.pinto.n...@gmail.com wrote:
Em 12 de abril de 2012 14:12, Phoenix Kiula phoenix.ki...@gmail.comescreveu:
I had pgbouncer working somehow, but we have switched servers recently
and now I cannot for the life of me figure out again how
Em 14 de abril de 2012 09:39, raghu ram raghuchenn...@gmail.com escreveu:
On Sat, Apr 14, 2012 at 4:31 PM, Clodoaldo Neto
clodoaldo.pinto.n...@gmail.com wrote:
Em 12 de abril de 2012 14:12, Phoenix Kiula
phoenix.ki...@gmail.comescreveu:
I had pgbouncer working somehow, but we have
On Sat, Apr 14, 2012 at 6:35 PM, Clodoaldo Neto
clodoaldo.pinto.n...@gmail.com wrote:
Em 14 de abril de 2012 09:39, raghu ram raghuchenn...@gmail.comescreveu:
On Sat, Apr 14, 2012 at 4:31 PM, Clodoaldo Neto
clodoaldo.pinto.n...@gmail.com wrote:
Em 12 de abril de 2012 14:12, Phoenix
On Sat, Apr 14, 2012 at 09:01:10AM +, Albretch Mueller wrote:
I wonder if anyone has ever gotten PostgreSQL Certified
https://www.google.com/search?q=postgresql+certificationie=utf-8oe=utf-8aq=trls=org.mozilla:en-US:officialclient=firefox-a
--
Sent via pgsql-general mailing list
On 2012-04-11, Kenneth Tilton ktil...@mcna.net wrote:
We are simulating a graph DB in Postgres and would have one RDF-like table
with columns as described above. If we want a trigger on what is
conventionally a column for color, with pseudo-RDF we would have:
create trigger ... when
On 2012-04-13, Jeff Adams jeff.ad...@noaa.gov wrote:
--e89a8ff1c1e8d37deb04bd922a84
Content-Type: text/plain; charset=ISO-8859-1
Thanks for the ideas Steve. I am actually working with a partitioned table
and the field I am modifying is the id field (I have reached the cap on the
integer data
On 2012-04-12, raghupradeep raghuprad...@gmail.com wrote:
Hi ,
I am basically a MySQL DBA and have little idea on PostgreSQL. In our
environment we have an application which is using PostgreSQL as its back
end. The application logs the status of the jobs running in it to a table in
this
15 matches
Mail list logo