chinchu2005 escribió:
>
> Hello all,
> Need ur help.I dont know wats wrong with the following fucntion.
> create or replace function twoarray() returns setof integer as
> '
> declare
> i integer;
> j integer;
> a integer[][];
> begin
> for i in 1..10 loop
> for j in 1..2 loop
> a[i][j]:=i*j;
We j
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Justin,
First of all thank you for your input. :)
Actually what I have is a fully internationalized site by means of
getttext.
*Some* of the content comes from the PGSQL database where 2 tables
relation with others (namely for sensor data descript
chinchu2005 writes:
> declare
> i integer;
> j integer;
> a integer[][];
> begin
> for i in 1..10 loop
> for j in 1..2 loop
> a[i][j]:=i*j;
This isn't going to work --- it implies dynamically resizing the array,
and plpgsql isn't smart enough to do that for a multidimensional array.
Do you actual
Hello all,
Need ur help.I dont know wats wrong with the following fucntion.
create or replace function twoarray() returns setof integer as
'
declare
i integer;
j integer;
a integer[][];
begin
for i in 1..10 loop
for j in 1..2 loop
a[i][j]:=i*j;
return next a[i][j];
end loop;
end loop;
return;
end;
Pedro Doria Meunier wrote:
Hi all,
I'm wondering how to internationalize contents of a table, short of
having a column for each language string ...
Anyone with some experience to share? :)
Regards,
Pedro Doria Meunier
How about parent child table layout. The child table has one record for
Steve Atkins wrote:
>
> On Mar 23, 2009, at 3:50 PM, Dann Corbit wrote:
>
> > If I have the C locale, can I have multiple character encodings
> > within:
> > 1. A single database?
> > 2. A single table?
>
> No.
>
> >
> > More specifically, I would like to be able to have Unicode columns and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I'm wondering how to internationalize contents of a table, short of
having a column for each language string ...
Anyone with some experience to share? :)
Regards,
Pedro Doria Meunier
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.7 (GNU/Li
On Mar 23, 2009, at 3:50 PM, Dann Corbit wrote:
If I have the C locale, can I have multiple character encodings
within:
1. A single database?
2. A single table?
No.
More specifically, I would like to be able to have Unicode columns and
ASCII text columns within the same table. Is this
- bf...@comcast.net wrote:
> This is embedded SQL in a .pgc file. You can see the "c_docket_date
> between :date1 and :date2" line in the select statement, which is
> where the dates are porcessed. If I pass a date in the mm-dd-
> format it works. However, the application I'm porting i
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Apr 10, 2009, at 10:15 AM, Justin Funk wrote:
Team Amazing,
I am building a massive database for storing the syslogs of a room of
servers. The database gets about 25 million entries a day, and need
to keep
them for 180 days. So the total siz
"Dann Corbit" writes:
> If I have the C locale, can I have multiple character encodings within:
> 1. A single database?
> 2. A single table?
No.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscriptio
Pavel Stehule wrote:
> 2009/4/10 :
> > Yes, I mentioned that I could use the to_date function, but as I said, that
> > would involve a LOT of changes to a LOT of source code, which I'm trying to
> > avoid.
> >
>
> other solution is custom datatype. It isn't too much work, but it is
> coding in C.
Justin Funk writes:
> Can you give me any tips and suggestions about how to speed this up?
Use fewer partitions --- 180 is a lot. Maybe weekly partitioning would
be about right.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of James B. Byrne
> Sent: Monday, April 06, 2009 1:46 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] INSERT or UPDATE
>
> I have spent the last couple of day
If I have the C locale, can I have multiple character encodings within:
1. A single database?
2. A single table?
More specifically, I would like to be able to have Unicode columns and
ASCII text columns within the same table. Is this possible? If so, how
do I achieve it?
It was not clear to m
Team Amazing,
I am building a massive database for storing the syslogs of a room of
servers. The database gets about 25 million entries a day, and need to keep
them for 180 days. So the total size of the database will be about 4.5
billion records.
I need to be able to do full text searches on the
Thanks a lot, Sam (and others), thanks to your help I managed to finally
produce the query I wanted.
Regards,
mk
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
2009/4/10 :
> Yes, I mentioned that I could use the to_date function, but as I said, that
> would involve a LOT of changes to a LOT of source code, which I'm trying to
> avoid.
>
other solution is custom datatype. It isn't too much work, but it is
coding in C.
regards
Pavel Stehule
> -Thanks
>
Yes, I mentioned that I could use the to_date function, but as I said, that
would involve a LOT of changes to a LOT of source code, which I'm trying to
avoid.
-Thanks
- Original Message -
From: "Pavel Stehule"
To: r...@iol.ie
Cc: "Bernard Barton" , pgsql-general@postgresql.org
This is embedded SQL in a .pgc file. You can see the "c_docket_date between
:date1 and :date2" line in the select statement, which is where the dates are
porcessed. If I pass a date in the mm-dd- format it works. However, the
application I'm porting is all based on dates in the mmdd form
Hello,
QUESTION1: Can somebody clarify in what of the proposed scenarios is the
following index used? Any further comment will be greatly appreciated.
QUESTION2: Does any other scenarios when an index is NOT used (and someone
might possibly expect it is used) come to your mind? Thank you v
Hello
use to_date function, please.
postgres=# select to_date('10122008','DDMM');
to_date
2008-12-10
(1 row)
Time: 1,152 ms
postgres=#
regards
Pavel Stehule
2009/4/10 Raymond O'Donnell :
> On 09/04/2009 23:56, Bernard Barton wrote:
>> Today I tried every permutation of the
On 09/04/2009 23:56, Bernard Barton wrote:
> Today I tried every permutation of the DateStyle parameter I could find, and
> still cannot get PostgreSQL 8.3 to accept dates in the format mmdd. I
> tried
How exactly are you sending these values to the database? Straight SQL,
or some other mech
linnewbie wrote:
> On Apr 9, 1:00 pm, st...@blighty.com (Steve Atkins) wrote:
>> On Apr 9, 2009, at 9:27 AM, linnewbie wrote:
>>
>>> Hi all,
>>> I have stored HTML in a text field that I subsequently render on the
>>> web. However when I retrieve and render this data on the web I am
>>> getting t
linnewbie wrote:
What I have on disk would be:
Bonnie & Clyde
which would usually be rendered as:
Bonnie & Clype
but this is not happening, it's being rendered
as:
Bonnie & Clyde
There are only three options.
1. That is *not* what you have stored in the database, it's being
escaped on t
25 matches
Mail list logo
