and summing up the values of 10 ids takes about 2.5
seconds, which looks to me like a quite a nice performance.
Petru Ghita
On 24/06/2010 15:05, Joshua Gooding wrote:
rules for
0x7CF29D04.asc
Description: application/pgp-keys
signature.asc
Description: OpenPGP digital signature
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
That field of yours... what type is it?
Is it TEXT? is it a numeric type?
If it's TEXT, why don't you make it say... NUMERIC(/10/, /6///)?
http://www.postgresql.org/docs/8.4/interactive/datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL
On 23/03/2010
?
- --
0.912
(1 row)
On 23/03/2010 2:50, Petru Ghita wrote:
That field of yours... what type is it? Is it TEXT? is it a numeric
type? If it's TEXT, why don't you make it say... NUMERIC(/10/,
/6///)?
http://www.postgresql.org/docs/8.4/interactive/datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
select 0.341*pow(10,length(0.341::text)-2);
2 is a constat that stands for the '0.' part of the string
representing the decimal part of the number.
Petru Ghita
On 23/03/2010 3:16, Neil Stlyz wrote:
This is good, however, I need only the numbers
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
For the record if you'd like to use regexp:
select substring('201.123' from $$[0-9]*$$);
and
select substring('201.1232' from $$\.([0-9]*)$$);
On 23/03/2010 4:42, Petru Ghita wrote:
select 0.341*pow(10,length(0.341::text)-2);
2 is a constat
to further help.
Petru Ghita
On 08/03/2010 13:25, query wrote:
Hi,
I want to display data for all days in a month even if no data
exists for that month. Some of the days in a month might not have
any data at all. With normal query, we can display days only if
data exists.But I want to display rows
. The immutable
property is used top determine if it's safe to use indexes or other
plans that avoid evaluating an expression repeatedly.
On 6 Mar 2010 02:45, Petru Ghita petr...@venaver.info
mailto:petr...@venaver.info wrote:
Given f1(x) as IMMUTABLE and f2(x) as IMMUTABLE, and f3(f1,f2) as
IMMUTABLE
?
Is this the recommended way to proceed?
Thank you!
Petru Ghita
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEARECAAYFAkuRwYQACgkQt6IL6XzynQTHEgCffi2QMWkkvTIsuglsanvcUyRB
I+wAoKr22B7FJJVDCssGKGwB8zr4NjQG
=V/BS
-END
-statements.html
under 37.6.5. Executing Dynamic Commands
Petru Ghita
Gianvito Pio wrote:
Hi all, is there a way to define functions and/or triggers in a
function?
For example, can I create a function that takes an argument and
defines a function that has the name passed as argument
comparison?
What would it be the fastest way of correctly implementing comparison
operators for the DATE type?
Thank you very much in advance,
Petru Ghita
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
10 matches
Mail list logo