a precision of numeric(100,90), which means 90
> decimals and that is exactly what you got!*
>
> *The result is correct, so what is your question?*
>
> --
> *Melvin Davidson*
> I reserve the right to fantasize. Whether or not you
> wish to share my fantasy is entirely up to you.
>
The original snippet reads:
select 1::numeric/3;
And I think Francisco is asking why only 20 digits.
--
Vincenzo Romano - NotOrAnd.IT
Information Technologies
--
NON QVIETIS MARIBVS NAVTA PERITVS
Quoting from documentation:
"without any precision or scale [you get] a column in which values of any
precision and scale can be stored, up to the implementation limit on
precision."
I suspect the cast is doing some precision limitation.
--
Vincenzo Romano - NotOrAnd.IT
Information Te
2017-08-24 12:06 GMT+02:00 Pavel Stehule :
>
>
> 2017-08-24 11:46 GMT+02:00 Vincenzo Romano :
>>
>> 2017-08-24 11:04 GMT+02:00 Pavel Stehule :
>> >
>> >
>> > 2017-08-24 9:11 GMT+02:00 Vincenzo Romano :
>> >>
>> >>
2017-08-24 11:04 GMT+02:00 Pavel Stehule :
>
>
> 2017-08-24 9:11 GMT+02:00 Vincenzo Romano :
>>
>> 2017-08-24 3:08 GMT+02:00 Tom Lane :
>> > "David G. Johnston" writes:
>> >> I'm wondering if there is anything technical preventing someon
.. is OK.
CREATE TABLE pg_temp.tablename ... is OK.
DROP TABLE pg_temp.tablename ... is OK.
DROP TEMP TABLE tablename ... is NOT OK.
Unless the standard explicitly forbids it, why not supporting both
syntaxes in all commands using the TABLE predicate?
Those are semantically equivalent. Aren't they
Il 18 ago 2017 21:59, "Vincenzo Romano" ha
scritto:
Il 18 ago 2017 21:08, "Igor Korot" ha scritto:
Hi, Vincenzo,
On Fri, Aug 18, 2017 at 2:52 PM, Vincenzo Romano
wrote:
> What I can tell you is not more of what is in the documentation.
>
> https://www.postgre
Il 18 ago 2017 21:08, "Igor Korot" ha scritto:
Hi, Vincenzo,
On Fri, Aug 18, 2017 at 2:52 PM, Vincenzo Romano
wrote:
> What I can tell you is not more of what is in the documentation.
>
> https://www.postgresql.org/docs/9.6/static/libpq-exec.
html#LIBPQ-EXEC-SELECT-INFO
>
What I can tell you is not more of what is in the documentation.
https://www.postgresql.org/docs/9.6/static/libpq-exec.
html#LIBPQ-EXEC-SELECT-INFO
In particular see the function PQBinaryTuples.
--
Vincenzo Romano - NotOrAnd.IT
Information Technologies
--
NON QVIETIS MARIBVS NAVTA PERITVS
Il
Afaik, pgresult structure and it's fields are not meant to be handled
directly apart of comparing the pointer to null.
--
Vincenzo Romano - NotOrAnd.IT
Information Technologies
--
NON QVIETIS MARIBVS NAVTA PERITVS
Il 18 ago 2017 19:46, "Igor Korot" ha scritto:
> Hi,
Il 28 lug 2017 16:18, "Tom Lane" ha scritto:
Vincenzo Romano writes:
> I would like to understand the typo protection mentioned by Tom earlier:
> I need to understand the reason for creating that special case.
Well, case A:
create function foo(out x int4) returns setof int
2017-07-28 8:36 GMT+02:00 David G. Johnston :
> On Thursday, July 27, 2017, David G. Johnston
> wrote:
>>
>> On Thursday, July 27, 2017, Vincenzo Romano
>> wrote:
>>>
>>> The main difference is that with RETURNS SETOF RECORD I still get the
>>&
2017-07-27 16:03 GMT+02:00 Tom Lane :
Thanks a lot for your reply with valuable details.
> Vincenzo Romano writes:
>> CREATE OR REPLACE FUNCTION afun1( OUT ot TEXT )
>> RETURNS SETOF RECORD
>
>> The error message for afun1() reads:
>> ERROR: function result ty
TEXT", but why
forcing me to "deviate" from a very general construct for a 1 column
case?
Is this a bug/enhancement or am I missing something?
TALIA!
--
Vincenzo Romano - NotOrAnd.IT
Information Technologies
--
NON QVIETIS MARIBVS NAVTA PERITVS
--
Sent via pgsql-general ma
In a fresh new install of PostgreSQL 9.5.2 on Ubuntu 16.04 I am getting this:
...
Setting up postgresql-9.5 (9.5.2-1.pgdg16.04+1) ...
Unescaped left brace in regex is deprecated, passed through in regex;
marked by <-- HERE in m/(?http://www.postgresql.org/mailpref/pgsql-general
PL/PgSQL doesn't know the pg_temp meta schema in case you need to
really work on that TEMP TABLE.
At the moment I had to move those DDL/DML queries within a "plain" SQL function.
Is this a feature or a bug? (Seriously, I mean! :-)
TIA.
--
Vincenzo Romano - NotOrAnd.IT
Informati
2013/7/25 Luca Ferrari :
> On Thu, Jul 25, 2013 at 2:57 AM, Some Developer
> wrote:
>> The added advantage of removing load from the app servers so they can
>> actually deal with serving the app is a bonus.
>
> Uhm...I don't know what application you are developing, but I don't
> buy your explaina
2013/7/24 Aaron Abreu :
> a NON-technical version...
>
> st.procedures and automation are great...
>
> but...
> sounds like everybody is dancing around the main theme..
> so lets say it
> that dreaded word that developers and DBA's cring to hear...
> the one part of our job that we all hate...
2013/7/24 Aaron Abreu :
> a NON-technical version...
>
> st.procedures and automation are great...
>
> but...
> sounds like everybody is dancing around the main theme..
> so lets say it
> that dreaded word that developers and DBA's cring to hear...
> the one part of our job that we all hate...
2013/7/17 Muhammad Bashir Al-Noimi :
> On Wed, Jul 17, 2013 at 3:34 PM, Vincenzo Romano
> wrote:
>> Once you "sudo add-apt-repository ppa:pitti/postgresql" then you go in
>> /etc/apt/sources.list.d/pitti* and you replace the word with your
>> Ubuntu version
2013/7/17 Muhammad Bashir Al-Noimi :
> Howdy,
>
> After upgrading my Pg from 9.1 to 9.2 the avaliable pgAdmin in ubuntu
> 21.10 reporotiy can't deal with Pg 9.2.
>
> How can I get recent pgAdmin version for ubuntu 12.10?
>
> P.S.
> - I tried ppa:pitti/postgresql but it doesn’t contain on suitable
>
I have done the following test pn v9.2.4 with two concurrent sessions:
-- session no.1
tmp1=# create table t1 ( t text );
CREATE TABLE
Tempo: 37,351 ms
tmp1=# create table t2 ( t text );
CREATE TABLE
Tempo: 33,363 ms
tmp1=# create or replace function f1( out tx text )
tmp1-# language plpgsql
tmp1-
2013/7/15 Luca Ferrari :
> On Mon, Jul 15, 2013 at 8:33 AM, Vincenzo Romano
> wrote:
>
>> The alternative is to do things the "good ol' way" by DELETING+INSERTING
>> (http://tapoueh.org/blog/2013/07/05-archiving-data-fast.html)
>> Where I'd fear for
2013/7/15 Luca Ferrari :
> On Sun, Jul 14, 2013 at 8:36 PM, Vincenzo Romano
> wrote:
>
>> I am only concerned about how late is done the binding between a table
>> name and the actual OID for other functions, views and triggers.
>
>
> Well, it should work like this:
2013/7/14 Luca Ferrari :
> On Fri, Jul 12, 2013 at 1:23 PM, Vincenzo Romano
> wrote:
>> Hi all
>> I'm making some experiments with table archiving and I'd like to
>> "replace" a full table F with an empty one E.
>> In order to do this I see only
2013/7/14 Haiming Zhang :
> Hi All,
>
>
>
> I am using postgres 9.1, I have a question about updating big table. Here is
> the basic information of this table.
>
> 1. This table has one primary key and other 11 columns.
>
> 2. It also has a trigger that before updat
> Vincenzo Romano wrote:
>
>> I'd like to "replace" a full table F with an empty one E.
>> In order to do this I see only one way:
>>
>> ALTER TABLE F RENAME TO T;
>> ALTER TABLE E RENAME TO F;
>> ALTER TABLE T RENAME TO E; -- optiona
;s a moment when the full table doesn't exist.
Would a transaction enclosure ensure that the table F will be always
available to all clients?
Thanks.
--
Vincenzo Romano - NotOrAnd.IT
Information Technologies
--
NON QVIETIS MARIBVS NAVTA PERITVS
--
Sent via pgsql-general mailing list (pgsql-g
2012/5/18 Tom Lane :
> Vincenzo Romano writes:
>> I'd need to check from a C language program whether the server is
>> running or not.
>> I was planning to use either "PGPing PQping(const char *conninfo)" or
>> "ConnStatusType PQstatus(const P
Hi all.
I'd need to check from a C language program whether the server is
running or not.
I was planning to use either "PGPing PQping(const char *conninfo)" or
"ConnStatusType PQstatus(const PGconn *conn)".
I have my program running and checking from time to time whether the
connection is kicking a
2012/4/25 Jasen Betts :
> On 2012-04-25, Valentin Militaru wrote:
>> This is a multi-part message in MIME format.
>> --050404030901030607030308
>> Content-Type: text/plain; charset=UTF-8; format=flowed
>> Content-Transfer-Encoding: 7bit
>>
>> What about using
>>
>> WHERE f BETWEEN '201
2012/4/23 Vincenzo Romano :
> Hi all.
> I know that the output of a decrypt() call (from pgcrypto module) can
> be safely converted to TEXT.
> CAST( decrypt( data,key,'bf' ) as TEXT ) (and other variants) just doesn't
> work.
> How can I (possibly easily) do it?
&
Hi all.
I know that the output of a decrypt() call (from pgcrypto module) can
be safely converted to TEXT.
CAST( decrypt( data,key,'bf' ) as TEXT ) (and other variants) just doesn't work.
How can I (possibly easily) do it?
Thanks.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.o
2012/4/20 Tom Lane :
> Vincenzo Romano writes:
>> The weirdness is that it doesn't produce any notice the first two times.
>> At the third invocation I see the notice coming out.
>
> I'd suggest tweaking the exception handler to print the error it caught;
> t
2012/4/20 Tom Lane :
> Vincenzo Romano writes:
>>> As you can see, the third time I get a NOTICE message I don't get the
>>> first two times.
>>> Everything works fine but this strange thing...
>
>> There's a typo (extra create temporary view), S
2012/4/20 Vincenzo Romano :
> 2012/4/20 Vincenzo Romano :
>> 2012/4/20 Tom Lane :
>>> Vincenzo Romano writes:
>>>> 2012/4/20 Vincenzo Romano :
>>>>> 2012/4/20 Tom Lane :
>>>>>> You might be able to use "DROP VIEW pg_temp.foo"
2012/4/20 Vincenzo Romano :
> 2012/4/20 Tom Lane :
>> Vincenzo Romano writes:
>>> 2012/4/20 Vincenzo Romano :
>>>> 2012/4/20 Tom Lane :
>>>>> You might be able to use "DROP VIEW pg_temp.foo", which will either
>>>>> d
2012/4/20 Tom Lane :
> Vincenzo Romano writes:
>> 2012/4/20 Vincenzo Romano :
>>> 2012/4/20 Tom Lane :
>>>> You might be able to use "DROP VIEW pg_temp.foo", which will either
>>>> drop a temp view of your own session or throw an error if ther
2012/4/20 Vincenzo Romano :
> 2012/4/20 Tom Lane :
>> Merlin Moncure writes:
>>> On Fri, Apr 20, 2012 at 10:51 AM, Vincenzo Romano
>>> wrote:
>>>> Ok. That works. How can I know if there's a temporary view with the
>>>> same name in m
2012/4/20 Tom Lane :
> Merlin Moncure writes:
>> On Fri, Apr 20, 2012 at 10:51 AM, Vincenzo Romano
>> wrote:
>>> Ok. That works. How can I know if there's a temporary view with the
>>> same name in my session?
>
>> well, arguably you should al
2012/4/20 Merlin Moncure :
> On Fri, Apr 20, 2012 at 10:36 AM, Vincenzo Romano
> wrote:
>> Hi all.
>> I'd like use a temporary view "to hide" a non-temp one for some queries.
>> Later I'd need to drop that view in order to "revert to normal op
IEW ..." in order to "overwrite" the temporary one
with the same code as the non-temporary.
All this sounds quite complex to me. Is there a way to drop temporary
stuff before closing the session?
TIA.
--
Vincenzo Romano - NotOrAnd.IT
Information Technologies
NON QVIETIS MARIBVS NAVT
, would it make any sense (and why) to use
wither GIN or GiST indexing?
I'll appreciate also any link to documentation or discussions about this topic.
Thanks.
--
Vincenzo Romano at NotOrAnd Information Technologies
Software Hardware Networking Training Support Security
--
NON QVIETIS M
I can experience in C++ with try/catch constructs.
But from time to time I read something on this very mailing list that
makes me think the reality is
different.
Is there any authoritative, and possibly proven, answer to this topic?
--
Vincenzo Romano at NotOrAnd Information Technologi
2010/9/30 Vincenzo Romano :
> 2010/9/30 Tom Lane :
>> Vincenzo Romano writes:
>>> create or replace function session_init()
>>> returns void
>>> language plpgsql
>>> as $body$
>>> declare
>>> t text;
>>> begin
>>&
2010/9/30 Vincenzo Romano :
> 2010/9/30 GOO Creations :
>> Hi there,
>>
>> I'm sitting for days now, and I can't get this to work:
>>
>> I want to insert binary data (bytea) into my postgres DB via the c++ libpq.
>>
>> What I have is a cha
v9 documentation.
http://www.postgresql.org/docs/9.0/static/libpq-exec.html#LIBPQ-EXEC-ESCAPE-STRING
--
Vincenzo Romano at NotOrAnd Information Technologies
Software Hardware Networking Training Support Security
--
NON QVIETIS MARIBVS NAVTA PERITVS
--
Sent via pgsql-general mailing list (pgsql-
2010/9/30 Pavel Stehule :
> 2010/9/30 Vincenzo Romano :
>> 2010/9/30 Pavel Stehule :
>>> Hello
>>>>> but if you need a session variables, then you can use a plperl
>>>>>
>>>>> http://www.postgresql.org/docs/9.0/static/plperl-globa
n.
>>
>
> understand - attention - session variables are nice but problematic
> when you use some form of connection pooling
I do know I'll need to be careful, even without connection pooling.
What'd be a different solution to implement session variables?
Just PLPERL?
--
Vin
2010/9/30 Andy Colson :
> On 9/30/2010 8:52 AM, Vincenzo Romano wrote:
>>
>> I was also thinking about using the catalog, but it looked to me
>> "easier" my way.
>> And, of course, if you have better advises for a "session variables"
>> soluti
2010/9/30 Pavel Stehule :
> Hello
>
> 2010/9/30 Tom Lane :
>> Vincenzo Romano writes:
>>> create or replace function session_init()
>>> returns void
>>> language plpgsql
>>> as $body$
>>> declare
>>> t text;
>>> beg
2010/9/30 Tom Lane :
> Vincenzo Romano writes:
>> create or replace function session_init()
>> returns void
>> language plpgsql
>> as $body$
>> declare
>> t text;
>> begin
>> select valu into t from session where name='SESSION_ID';
2010/9/30 Ben Carbery :
> On Thu, Sep 30, 2010 at 9:36 PM, Vincenzo Romano
> wrote:
>>
>> We also have the fantastic crosstab in tablefunc module (see chapter
>> F.36.1.4 for v9.0.0)
>>
> ..but these seem to be more pivot table functions that alter the
fantastic crosstab in tablefunc module (see chapter
F.36.1.4 for v9.0.0)
--
Vincenzo Romano at NotOrAnd Information Technologies
Software Hardware Networking Training Support Security
--
NON QVIETIS MARIBVS NAVTA PERITVS
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To m
2010/9/30 Ben Carbery :
> Strange if this can't be done, I would have thought it a common request!
Just curiosity. Is there any other DB capable of such a thing?
--
Vincenzo Romano at NotOrAnd Information Technologies
Software Hardware Networking Training Support Security
--
NON QVIETIS
SQL
--
This means that the "if not found then" in the function body didn't work well.
The idea is to create a temporary table to store session variables
only of there's no temporary table with that name.
Any hint on this?
--
Vincenzo Romano at NotOrAnd Information Technologies
S
first level *and* by day (28,29,30 or 31) on the second one)
would do the magics, but here the DDL would be quite killing,
even with some PL/PGSQL helper function.
The "linearity" of the index selection killed the performances also in
the "really lots of partial indexes&qu
t near
> Access' two gigabyte database size limit, I'm a little nervous of these
> much bigger files. So I'd appreciate anyone's advice here.
>
AFAIK it could be just a matter of how much RAM do you have, DDL and
DML (aka queries).
Hitting the real PG limits it'
a training (and costs), as if people would remain there forever and
knowledge is a definitive thing!
THe point would be to put costs in a time perspective, that is, how
much would it cost in,
say, 5 years, with PG and the same for Oracle.
--
Vincenzo Romano
NotOrAnd Information Technologies
NON
2010/7/27 Dimitri Fontaine :
> Vincenzo Romano writes:
>> Now, why doing this?
>> I am using a plain SEQUENCE to create a (kind of) "session ID". That
>> is simple but predictable.
>> The idea is to use this function in conjunction with encrypt (from
>>
2010/7/26 Vincenzo Romano :
> 2010/7/26 Pavel Stehule :
>> Hello
>>
>> you can try
>>
>> postgres=# select int8send(256);
>> int8send
>>
>> \x0100
>> (1 row)
>>
>> for con
x27;s a longer backstory here that I'm happy to explain if
> necessary.) I'm looking for an efficient way to dump all the data in the DB
> without having to SELECT * on each table.
>
> Thanks in advance!
> Scott
You can use COPY but you won't easily have the DD
2010/7/26 A. Kretschmer :
> In response to Vincenzo Romano :
>> 2010/7/26 A. Kretschmer :
>> > In response to Ivan Voras :
>> >> * buy external storage (NAS, or even an external USB drive), move the
>> >> database to it
>> >
>> > buy ex
(performance and reliability) is
more important by far ...
--
Vincenzo Romano
NotOrAnd Information Technologies
NON QVIETIS MARIBVS NAVTA PERITVS
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
2010/7/26 Pavel Stehule :
> Hello
>
> you can try
>
> postgres=# select int8send(256);
> int8send
>
> \x0100
> (1 row)
>
> for converting from bytea to int8 you need a custom function - probably in C
> :(
int8send?
--
2010/7/26 Vincenzo Romano :
> Hi all.
>
> I'd like to convert an 8-bytes BYTEA into a BIGINT and possibly vice versa.
> Is there any way to do it?
Something like:
CREATE OR REPLACE FUNCTION bytea_to_int8( ba BYTEA, OUT res INT8 )
LANGUAGE plpgsql STRICT
AS $BODY$
DECLARE
i
Hi all.
I'd like to convert an 8-bytes BYTEA into a BIGINT and possibly vice versa.
Is there any way to do it?
--
Vincenzo Romano
NotOrAnd Information Technologies
NON QVIETIS MARIBVS NAVTA PERITVS
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
E itself with something like "EXECUTE SPRINTF ".
Does this make any sense to you all?
--
Vincenzo Romano
NotOrAnd Information Technologies
NON QVIETIS MARIBVS NAVTA PERITVS
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi all.
I'd like to know how efficient is inheritance when the number of
children gets higher and higher.
I mean both with and without the constraint exclusion.
Will this change with 9.0 or possibly 9.1?
Thanks.
--
Vincenzo Romano
NotOrAnd Information Technologies
NON QVIETIS MARIBVS
It strongly depends from the queries. Usually yes
Il giorno 2010 5 15 16:20, "Armand Turpel" ha scritto:
Hi,
Does it make sense to create indexes on a table which only contains bigint
fields? Is there any performance gain?
Example:
Table x_rel
id_a bigint
id_b bigint
id_c bigint
id_d bigint
T
; Hum, not sure. If I understand correctly, you won't be able to get the
> original int64 from the generated one.
Why should I bother?
> Better rewrite the function for 2^64 isn't it ?
Sure!.
--
Vincenzo Romano
NotOrAnd Information Technologies
NON QVIETIS MARIBVS
2010/5/4 Alvaro Herrera :
> Vincenzo Romano wrote:
>> Hi all.
>>
>> I'm willing to change an BIGINT ID column (actually a SERIAL8) with a
>> BIGINT whose valules are (pseudo)random.
>> The main objective is to avoid guessability.
>> I whish I could al
Hi all.
I'm willing to change an BIGINT ID column (actually a SERIAL8) with a
BIGINT whose valules are (pseudo)random.
The main objective is to avoid guessability.
I whish I could also use it as the PK (as it's now) but that's not
really important now.
Any hint?
--
Vincenzo
2010/5/3 Justin Pasher :
> - Original Message -
>>
>> From: Vincenzo Romano
>> Date: Mon, 3 May 2010 17:59:10 +0200
>> Subject: Re: Latest source RPMs for 8.1.20
>> To: Justin Pasher
>> CC: pgsql-general@postgresql.org
>>
>> 2010/5/3 Ju
2010/5/3 Vincenzo Romano :
> 2010/5/3 Justin Pasher :
>> - Original Message -
>>>
>>> From: Vincenzo Romano
>>> Date: Mon, 3 May 2010 17:59:10 +0200
>>> Subject: Re: Latest source RPMs for 8.1.20
>>> To: Justin Pasher
>>>
patch files.
>
> Thanks.
Just curiosity: why are you using 8.1?
--
Vincenzo Romano
NotOrAnd Information Technologies
NON QVIETIS MARIBVS NAVTA PERITVS
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
2010/5/1 Greg Smith :
> Vincenzo Romano wrote:
>>
>> While I can agree that "Enterprise grade" is a buzzword, it does mean
>> something: "very large amount of data" among other.
>>
>
> http://thedailywtf.com/Articles/Bitten_by_the_Enterprise_Bug
2010/5/1 Greg Smith :
> Vincenzo Romano wrote:
>>
>> I argued that O(n) stuff will keep it away from "enterprise grade"
>> applications.
>> I've been told earlier that "It is fine for dozens of child tables,
>> but not thousands;
>>
2010/4/30 Alvaro Herrera :
> Vincenzo Romano wrote:
>
>> In this specific case, if you think about "inheritance for
>> partitioning" and you stick with the example idea of "one partition
>> per month", then the current solution is more than OK.
>>
s Ciencias Informáticas.Ciudad de la Habana. Cuba.
> «"Se tu el cambio que quieres ver en el mundo"..."El éxito es el fracaso
> superado por la perseverancia"»
pgsql-general@postgresql.org, pgsql-annou...@postgresql.org are
english language lists.
So Spanish is not really
2010/4/30 Vincenzo Romano :
> 2010/4/30 David Fetter :
>> On Thu, Apr 29, 2010 at 11:29:36AM +0200, Vincenzo Romano wrote:
>>> > No info about this point (partial indexes)?
>>> > Is also this geared with linear algorithms ?
>>>
>>> Should I
2010/4/30 David Fetter :
> On Thu, Apr 29, 2010 at 11:29:36AM +0200, Vincenzo Romano wrote:
>> > No info about this point (partial indexes)?
>> > Is also this geared with linear algorithms ?
>>
>> Should I move to an "enterprise grade" version of Post
2010/4/26 Vincenzo Romano :
> 2010/4/26 Bruce Momjian :
>> Vincenzo Romano wrote:
>>> Hi all.
>>>
>>> I'm wondering how efficient the inheritance can be.
>>> I'm using the constraint exclusion feature and for each child table
>>> (ma
response due to
some email forwarding ...
Anyway, don't follow those directions if you are not involved into that domain!
--
Vincenzo Romano
NotOrAnd Information Technologies
NON QVIETIS MARIBVS NAVTA PERITVS
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
2010/4/27 Greg Smith :
> a.bhattacha...@sungard.com wrote:
>>
>> I have *622,000 number of records *but it is taking almost *4 and half
>> hours* to load these data into the tables.
Without the schema and the queries, all you can get is guessing.
--
Vincenzo Romano
2010/4/26 Bruce Momjian :
> Vincenzo Romano wrote:
>> Hi all.
>>
>> I'm wondering how efficient the inheritance can be.
>> I'm using the constraint exclusion feature and for each child table
>> (maybe but one) I have a proper CHECK constraint.
>> H
xes?
Will these answers change in v9?
--
Vincenzo Romano
NotOrAnd Information Technologies
NON QVIETIS MARIBVS NAVTA PERITVS
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
self in RAM.
Of course, poor indexing can kill any effort.
--
Vincenzo Romano
NotOrAnd Information Technologies
NON QVIETIS MARIBVS NAVTA PERITVS
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
E
> original alias for $1;
> reverse_str text;
> i int4;
> BEGIN
> reverse_str := '';
> FOR i IN REVERSE LENGTH(original)..1 LOOP
> reverse_str := reverse_str || substr(original,i,1);
> END LOOP;
> RETURN reverse_str;
> END;$_$
>
Look for crosstab in the documentation.
Il giorno 8 feb, 2010 8:21 p., "Davor J." ha scritto:
Let's say you have a table:
CREATE TABLE t (
time date,
data integer
)
Suppose you want a new table that has columns similar to the following:
"(x.time, x.data, y.time, y.data, z.time, z.data)" where x
; I take it you're staying the licence page needs updating? Maybe some
> licence clarification should coincide with v9?
>
> Thom
Updating the license page?
Isn't the license page the official license statement?
If so, any other Postgres lilcensing reference should point to it.
I
to the
proper child table?
--
Vincenzo Romano
NotOrAnd Information Technologies
NON QVIETIS MARIBVS NAVTA PERITVS
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Uuid?
Il giorno 29 gen, 2010 9:20 m., "Joe Kramer" ha
scritto:
Hello,
I need to generate unique id which is not guessable unlike
serial(integer) type. I need an id in format like md5 hash of random
number.
On top of that I need this id to be unique across multiple tables.
Anyone had to solve t
2010/1/29 沈雷 :
> Hi!
>
> In C Language, there is a way to format float numbers into a hex string by
> using "%a" in printf.
> eg:
> the value: 1.2345 can be expressed as '0x1.3c083126e978dp+0' which is the
> hex representation of a float number.
>
> I have tried this in Postgres:
> SELECT '0x1.3c08
2010/1/27 Tom Lane :
> Vincenzo Romano writes:
>> But why still on separate schema?
>> I'd rather put them all in the public one, so you don't need the "pst."
>> anymore.
>> Just like (most of) all other contrib modules ...
>
> If this were t
2010/1/27 Pavel Stehule :
> 2010/1/27 Vincenzo Romano :
>> But why still on separate schema?
>> I'd rather put them all in the public one, so you don't need the "pst."
>> anymore.
>> Just like (most of) all other contrib mudules ...
>
> if
2010/1/27 Pavel Stehule :
> Hello
>
> I add sprintf function. Now I think, we can add new contrib module
> (string functions) with both function - format and sprintf. These
> functions are relative different, so they can exists separately.
> Format is simpler and faster. Sprintf is more powerful bu
f children increases? Is it linear or what?
MTIA.
--
Vincenzo Romano
NotOrAnd Information Technologies
NON QVIETIS MARIBVS NAVTA PERITVS
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
2010/1/25 Pavel Stehule :
> 2010/1/25 Vincenzo Romano :
>> 2010/1/23 Pavel Stehule :
>>> 2010/1/22 Vincenzo Romano :
>>>> 2010/1/22 Tom Lane :
>>>>> Vincenzo Romano writes:
>>>>>> 2010/1/22 Tom Lane :
>>>>>>> r
2010/1/25 Pavel Stehule :
> 2010/1/25 Vincenzo Romano :
>> 2010/1/23 Pavel Stehule :
>>> 2010/1/22 Vincenzo Romano :
>>>> 2010/1/22 Tom Lane :
>>>>> Vincenzo Romano writes:
>>>>>> 2010/1/22 Tom Lane :
>>>>>>> r
2010/1/23 Pavel Stehule :
> 2010/1/22 Vincenzo Romano :
>> 2010/1/22 Tom Lane :
>>> Vincenzo Romano writes:
>>>> 2010/1/22 Tom Lane :
>>>>> regression=# CREATE FUNCTION q( fmt text, variadic args "any" )
>>>
>>>> And th
1 - 100 of 196 matches
Mail list logo
