On 11/16/06, A. Kretschmer <[EMAIL PROTECTED]> wrote:
am Thu, dem 16.11.2006, um 16:31:14 -0200 mailte Ezequias Rodrigues da
Rocha folgendes:
> Hi list,
>
> I have a bigint collumn and I would like to generate a random number
within the
> numbers of my column.
select from order by random() l
Hi
Yes, but I must convert diffrent columns to diffrent iso-codes.
With pg_dump I can only dump all columns from database and these all columns
convert only to one iso-code.
On Fri, 17 Nov 2006 14:11:25 -0500, Travis Whitton wrote
> There might be better ways, but you could dump the data and u
On 11/15/06, Luca Ferrari <[EMAIL PROTECTED]> wrote:
On Wednesday 15 November 2006 16:20 your cat, walking on the keyboard,
wrote:
> May be you could show the results you are getting and then make up some
> results that you would really like to get. I am not entirely clear what
> you are trying
Hi
New database must be in SQL_ASCII. In old database (UNICODE) are for example
2 columns. Rows from first column I must convert to ISO_8859_2 and insert it
to first column in SQL_ASCII database, and rows from second column I must
convert to IS0_8859_5 and insert to second column in SQL_ASCII d
How about pg_dump the data from your old database, then load it into
your new database which is using UTF8?
Drew
On Nov 17, 2006, at 9:09 AM, lms wrote:
Hello
I have 2 databases with same table. First database is in UNICODE,
second in
SQL_ASCII.
4 columns from first database I must conv
I have a planner question about a multi-join query, where if I
rewrite the query excluding the table that is left joined to the
other tables my query speed increases by 75%.
I've tested this query on both 8.0.9 and 8.2b3, w/ similar results
(except 8.2b3 is 50% faster!)
I'm wondering why
Hello
I have 2 databases with same table. First database is in UNICODE, second in
SQL_ASCII.
4 columns from first database I must convert to:
(first column)iso8859-1,
(second column)iso8859-2,
(3-th column)iso8859-1,
(4 column)iso8859-5.
After it I must save these 4 rows in database in SQL_
am Fri, dem 17.11.2006, um 15:15:25 +0530 mailte Penchalaiah P. folgendes:
> Hi
>
> When I am executing my function its giving error.. first time its running
> properly.. but when I am executing second time I am getting error
>
> create or replace function irla_punching_medium_insert1(in_proj_co
Penchalaiah P. wrote:
Hi
When I am executing my function its giving error.. first time its
running properly.. but when I am executing second time I am getting
error
create table dummy_table without oids as
...
update dummy_table set irla_code=l_p where irla_code=''P'';
...
ERR
Hi
When I am executing my function its giving error.. first time its
running properly.. but when I am executing second time I am getting
error
create or replace function irla_punching_medium_insert1(in_proj_code
numeric,in_pt_code varchar,in_mon_abs date) returns varchar as'
declare
l_p va
10 matches
Mail list logo
