Re: [SQL] Finding Max Value in a Row

@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql -- --- Viktor Bojović --- Wherever I go, Murphy goes with me

Re: [SQL] Is there a way to remove every character but numbers?

be transformed in 00 in the same step. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/**mailpref/pgsql-sqlhttp://www.postgresql.org/mailpref/pgsql-sql try regexp_replace -- --- Viktor

Re: [SQL] Subselects to Joins? Or: how to design phone calls database

, and then do a inner join with prefixes table? Mario -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql -- --- Viktor Bojović

[SQL] function based index problem

-- --- Viktor Bojović --- Wherever I go, Murphy goes with me

Re: [SQL] function based index problem

)::text) = 36805) (2 rows) Thanx in advance -- --- Viktor Bojović --- Wherever I go, Murphy goes with me ** ** Some observations/suggestions: ** ** Please do not Cross-Post You have not provided your

Re: [SQL] which is better: using OR clauses or UNION?

changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql -- --- Viktor Bojović --- Wherever I go, Murphy goes with me

Re: [SQL] overload

?? --- Wherever I go, Murphy goes with me -- --- Viktor Bojovi?? --- Wherever I go, Murphy goes with me -- --- Viktor Bojović

Re: [SQL] overload

{ $patterns{$patt}++; } } } foreach $patt (keys %patterns){ my $sql=insert into patterns values('.$patt.',.$patterns{$patt}.); spi_exec_query($sql); } return ''; $BODY$ LANGUAGE plperl VOLATILE COST 100; On Mon, Jul 11, 2011 at 4:42 PM, Viktor Bojović viktor.bojo

Re: [SQL] overload

?? --- Wherever I go, Murphy goes with me -- --- Viktor Bojović --- Wherever I go, Murphy goes with me

[SQL] overload

}.); spi_exec_query($sql); } return ''; $BODY$ LANGUAGE plperl VOLATILE COST 100; -- --- Viktor Bojović --- Wherever I go, Murphy goes with me

Re: [SQL] Sqlite to postgres database conversion.swedish chararacter issue

be appriciated. Thanks, Sara -- --- Viktor Bojović --- Wherever I go, Murphy goes with me

Re: [SQL] PLpgSQL variables persistance between several functions calls

and within different calls just using memory (not tables or other methods). If it is really possible ? Thanks in advance, Chuck -- --- Viktor Bojović --- Wherever I go, Murphy goes with me

[SQL] function timeout

for that function. -- --- Viktor Bojović --- Wherever I go, Murphy goes with me

Re: [SQL] is there a refactor

on the search string. Thanks in advance, Johnf -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql -- --- Viktor Bojović

Re: [SQL] pg_attributte, data types

. These are type examples: _char _float4 _int2 _oid _regtype _text _varchar Those are array types. The normal convention is that foo[] is named _foo under the surface. regards, tom lane thanx -- --- Viktor Bojović

[SQL] pg_attributte, data types

-- --- Viktor Bojović --- Wherever I go, Murphy goes with me

Re: [SQL] How to workaround DROP CONSTRAINT [ IF EXISTS ] in Postgres version 8.1?

(pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql -- --- Viktor Bojović --- Wherever I go, Murphy goes with me

Re: [SQL] aggregation of setof

) RETURNS anyarray AS $BODY$ SELECT $1 LIMIT 1; $BODY$ LANGUAGE 'sql' STABLE; à ERROR: functions cannot accept set arguments *Von:* Viktor Bojović [mailto:viktor.bojo...@gmail.com] *Gesendet:* Samstag, 29. Januar 2011 09:28 *An:* Andreas Gaab *Betreff:* Re: [SQL] aggregation

Re: [SQL] Automating PostgreSql table partition using triggers

time with modified conditions for each separate testing_id. With regards Amitabh -- --- Viktor Bojović --- Wherever I go, Murphy goes with me

Re: [SQL] failing to connect to postgresql with php

running locally and accepting connections on Unix domain socket /var/run/postgresql/.s.PGSQL.5432? can someone help me out please if not started start it using /etc/init.d/postgresql-8.3 start -- --- Viktor Bojović

Re: [SQL] data import

copy On Dec 21, 2010, at 06:34 , Viktor Bojović wrote: Hi, can anyone recommend me a windows and linux free tools for importing data into postgre. Source files are CSV or excel. Thanx in advance -- --- Viktor Bojović

[SQL] data import

Hi, can anyone recommend me a windows and linux free tools for importing data into postgre. Source files are CSV or excel. Thanx in advance -- --- Viktor Bojović --- Wherever I go, Murphy goes with me

Re: [SQL] How to convert string to integer

.. Thanks select SUM(pan_1::integer) from customers1 where name='101' also you can use conversion functions described here http://www.postgresql.org/docs/8.2/static/functions-formatting.html -- --- Viktor Bojović --- Wherever

[SQL] constraint with check

), check (node=true) thanx in advance -- --- Viktor Bojović --- Wherever I go, Murphy goes with me

Re: [SQL] large xml database

On Sun, Oct 31, 2010 at 7:08 AM, Lutz Steinborn l.steinb...@4c-ag.dewrote: On Sat, 30 Oct 2010 23:49:29 +0200 Viktor Bojović viktor.bojo...@gmail.com wrote: many tries have failed because 8GB of ram and 10gb of swap were not enough. also sometimes i get that more than 2^32 operations

Re: [SQL] large xml database

On Sun, Oct 31, 2010 at 2:26 AM, James Cloos cl...@jhcloos.com wrote: VB == Viktor Bojović viktor.bojo...@gmail.com writes: VB i have very big XML documment which is larger than 50GB and want to VB import it into databse, and transform it to relational schema. Were I doing

Re: [SQL] large xml database

load the xml into the database, then parse that xml into instance of objects (rows in tables)? Yes. That way takes less ram then using twig or simple xml, so I tried using postgre xml functions or regexes. -- --- Viktor Bojović

Re: [SQL] large xml database

On Sun, Oct 31, 2010 at 10:26 PM, Rob Sargent robjsarg...@gmail.com wrote: Viktor Bojović wrote: On Sun, Oct 31, 2010 at 9:42 PM, Rob Sargent robjsarg...@gmail.commailto: robjsarg...@gmail.com wrote: Viktor Bojovic' wrote: On Sun, Oct 31, 2010 at 2:26 AM, James Cloos

[SQL] large xml database

to ask if someone knows how to speed this up. thanx in advance -- --- Viktor Bojović --- Wherever I go, Murphy goes with me

Re: [SQL] insert into table from list or array ?

subscription: http://www.postgresql.org/mailpref/pgsql-sql -- --- Viktor Bojović --- Wherever I go, Murphy goes with me

Re: [SQL] get attribute from XML

-07-07 dataset=S created=2009-06-16 /' ); xpath -- {2009-07-07} (1 row) HTH M.S. On Tue, Oct 12, 2010 at 1:03 AM, Viktor Bojović viktor.bojo...@gmail.com wrote: Hi, while parsing this type of XML: entry version=21 modified=2009-07-07 dataset=S created=2009-06-16

[SQL] get attribute from XML

help me with that. Thanx in advance -- --- Viktor Bojović --- Wherever I go, Murphy goes with me

[SQL] naming arguments in aggregate function

) ( SFUNC = grafika._tran_pov_sphere, STYPE = varchar, INITCOND = '' ); when i change the header to this CREATE AGGREGATE grafika.agg_pov_sphere (x numeric, y numeric, z numeric, rad numeric, pigment varchar) ( i get syntax error. Thanx in advance -- --- Viktor

[SQL] aggregate function

); Thanx in advance. -- --- Viktor Bojović --- Wherever I go, Murphy goes with me

Re: [SQL] strangest thing happened

, but no data will be inserted. If needed I will send you some code examples where it happened to me many times. Sincerely -- --- Viktor Bojović --- Wherever I go, Murphy goes with me

Re: [SQL] How to Get Column Names from the Table

\d tableName On Wed, Jul 7, 2010 at 11:08 AM, venkat ven.tammin...@gmail.com wrote: Dear All, How to get Column Names from Table in PostgreSQL. Thanks and Regards, Venkat -- --- Viktor Bojović --- Wherever I