Is there any good documentation, example, tutorial, pamphlet, discussion... to
exploit pg features to obtain polymorphic behavior without renouncing to
referential integrity?
Inheritance seems *just* promising.
Any methodical a approach to the problem in pg context?
--
Ivan Sergio Borgonovo
explicit mention inheritance.
I saw this too, more on the track of what I was looking for, but it wasn't
inspirational as I hoped:
http://www.varlena.com/varlena/GeneralBits/98.php
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast
On Sun, 8 Oct 2006 14:09:53 +0200
Karsten Hilbert [EMAIL PROTECTED] wrote:
On Fri, Oct 06, 2006 at 11:09:29PM +0200, Ivan Sergio Borgonovo
wrote:
Is there any good documentation, example, tutorial, pamphlet,
discussion... to exploit pg features to obtain polymorphic
behavior without
generated sp.
So I could define deferred referential integrity nearby table definitions as
I was used with pk/fk triggers.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Resending since it definitively seems it has been lost in outer spaces.
Sorry for duplicates if any.
On Sun, 8 Oct 2006 14:09:53 +0200
Karsten Hilbert [EMAIL PROTECTED] wrote:
On Fri, Oct 06, 2006 at 11:09:29PM +0200, Ivan Sergio Borgonovo
wrote:
Is there any good documentation, example
On Fri, 13 Oct 2006 16:37:42 +0200
Karsten Hilbert [EMAIL PROTECTED] wrote:
On Thu, Oct 12, 2006 at 04:40:32PM +0200, Ivan Sergio Borgonovo
wrote:
Anyway it doesn't solve the problem of having lists that
can contain different elements with same parent and maintain
ref. integrity.
Only
Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 6: explain analyze is your friend
('') in spite of NULL.
Am I missing something or it is a well known feature?
thx
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
AS '' and without it I can't still import NULL
without pre-processing.
I thought it may be missing total support of UTF-8 or if I did
something wrong or it is actually a feature.
thx
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast
get
without NULL AS ''.
Correct?
If it is I found the documentation a bit misleading. I admit it could
be due to not being English mother tongue.
thx
[1] I did try with '', '', '\\'...
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast
/postgresql_inheritance_surprises
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
be curious to see it happening indeed.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
be curious to see it happening indeed.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
then
insert into _table (uid, aid, qty)
values(_uid,_aid,_qty);
end if;
end;
' language plpgsql;
Is it going to perform worse than with a static table name?
Where can I find some clue about the effects of similar decisions?
thx
--
Ivan Sergio Borgonovo
http
On Mon, 03 Dec 2007 19:06:29 +
Richard Huxton [EMAIL PROTECTED] wrote:
Ivan Sergio Borgonovo wrote:
Any general rule about dynamically generated queries in stored
procedures vs. performances?
It's the same decision as any with any prepared plan vs
plan-each-time trade-off.
Should I
Functions
Still I can't understand some things, I'll come back.
thanks for the right pointers.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
everything will
reach a defined deterministic state after all ;)
Note that this is quite old now, so some performance-related
assumptions will be wrong for current versions of PG.
I noticed. Maybe this will be part of some other question later.
--
Ivan Sergio Borgonovo
http
, is there any other way to
auto-drop sequences when columns get dropped?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
not null
);
insert into temp1 (fk1,ak) select
insert into DESTtable2 (pk2,fk1,...)
select (pk2,fk1...) from SRC2
join temp1 ...
);
alter sequence seq_DESTtable2 RESTART currval('seq_temp1');
But it looks awful.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
?
btw set bolean_column= not bolean_column works as expected.
template1=# select (not 't'::boolean),(not 'f'::boolean),(not
NULL::boolean);
?column? | ?column? | ?column?
--+--+--
f| t|
(1 riga)
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
I
would expect since all NULL are converted to t.
template1=# select case when NULL then 'f'::boolean else 't'::boolean
end;
case
--
t
(1 riga)
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 6: explain
);
insert into pippo values(7,6);
select type_id, count(*) from pippo group by type_id having
count(*)=1;
10;1
6;1
2;1
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 5: don't forget to increase your free space
interesting stuff about Postgres, SQL and DB.
[1] In general; commonly; extensively, __though not universally__;
most frequently.
BTW it is not a case that Computer Science and *Information*
Technology are strict relatives
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
interesting stuff about Postgres, SQL and DB.
[1] In general; commonly; extensively, __though not universally__;
most frequently.
BTW it is not a case that Computer Science and *Information*
Technology are strict relatives
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
-mysql just to learn from it?
What about interesting DB abstraction layers that works with postgres
and at least 2 more other DB?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 1: if posting/reading through Usenet
to python vs. php.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Wed, 12 Dec 2007 15:11:50 -0600
D. Dante Lorenso [EMAIL PROTECTED] wrote:
SELECT SUBSTR('ABCDEFGHIJKLMNOP', -4);
there is an example in the manual... still regexpyous
http://www.postgresql.org/docs/8.1/static/functions-string.html
substring('Thomas' from '...$') - mas
--
Ivan Sergio
with the same problem mmm 1 month ago.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
design and how to deal with similar problems
that has some postgres spice?
thx
and yep pgsql community is great.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ
and you don't want it.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Wed, 19 Dec 2007 17:24:52 +0100
Ivan Sergio Borgonovo [EMAIL PROTECTED] wrote:
I've something like this:
create table i (
iid serial primary key,
name varchar(32)
);
create table p (
pid serial primary key,
iid int references i(iid) on delete cascade
On Thu, 20 Dec 2007 09:55:29 -0600
Erik Jones [EMAIL PROTECTED] wrote:
On Dec 20, 2007, at 8:50 AM, Ivan Sergio Borgonovo wrote:
On Wed, 19 Dec 2007 17:24:52 +0100
Ivan Sergio Borgonovo [EMAIL PROTECTED] wrote:
I've something like this:
create table i (
iid serial primary
a
double meaning.
It is cleaner to split the meanings and the data. This will even give
me a chance to avoid completely the concept of default property.
thanks, I think you put me on the right path.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast
On Fri, 21 Dec 2007 08:19:08 +
Richard Huxton [EMAIL PROTECTED] wrote:
Ivan Sergio Borgonovo wrote:
The default property (that is actually made by several fields) in
my case is not completely homogeneous with the others, because it
has a double meaning.
It is cleaner to split
'));
If not any way to make it static and avoid passing one more parameter
to the function?
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 6: explain analyze is your friend
,
not just the changed ones?
Is it faster to delete insert or to update?
updates comes with the same pk as the destination table.
thx
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 6: explain analyze is your friend
,
not just the changed ones?
Is it faster to delete insert or to update?
updates comes with the same pk as the destination table.
thx
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 6: explain analyze is your friend
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Sat, 29 Dec 2007 10:16:50 +0100
Andreas Kretschmer [EMAIL PROTECTED] wrote:
Ivan Sergio Borgonovo [EMAIL PROTECTED] schrieb:
or/and is there something to spot what are the most critical sql
queries/function behind an application?
You can set log_min_duration_statement in your
of arguments?
I'm going to go with 1) but well it would be nice if I discover
something nicer.
thx
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http
declaring a composite type explicitly?
thx
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Fri, 4 Jan 2008 09:38:35 +0100
Ivan Sergio Borgonovo [EMAIL PROTECTED] wrote:
create or replace function testA(out _BasketID1 int, out _BasketID2
int) as $$
begin
_BasketID1:=1;
_BasketID2:=2;
return;
end;
$$ language plpgsql;
create or replace function testB(out
unfaithful without needing it ;)
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
On Sun, 06 Jan 2008 02:47:17 -0500
Tom Lane [EMAIL PROTECTED] wrote:
Ivan Sergio Borgonovo [EMAIL PROTECTED] writes:
But when I switch to
select into _BasketID1,_BasketID2 _BasketID1,_BasketID2 from
testA(); nothing get back from testB().
I think you've forgotten that plpgsql variables
Cool. How do you sync the power supplies?
And thanks for the work.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 6: explain analyze is your friend
that are already
finished in stand by slowing the whole system?
I know you can limit requests and let responses run free, but what if
they are asking back 1M record with a simple query?
thx
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast
and function reference to objects?
thx
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
of such a bad design?
Or did you just mean that count(*) is bad design in postgresql since
there are usually better alternatives in postgresql?
I'm not joking. I'd like to learn.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast
will incur in the same problem
of what exact means.
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL
advantages plenty pay off the slowness of an operation that in such
a context is rare.
thanks
[1] or does postgres perform as the concurrence once you add where
clauses?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP
importing a table does it make any sense to pre-sort it
before importing it in postgres?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
on b) would be much appreciated. Other cases require just a
yes/no answer.
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
you don't
have budgets and hits enough to justify a complex logic to do stats
analysis or collect enough stats to make any forecast reasonable.
In this context a simpler faster even if less accurate count may be
very handy.
thanks again
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
not concerned of the deleted rows?
Just to get an estimate between reindexing cycles, that would be
perfect for paging.
pg_class does look as returning all the rows.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 1
On Wed, 9 Jan 2008 13:45:10 -0600
Scott Marlowe [EMAIL PROTECTED] wrote:
But my account rep told me it was easy, and he'd never lie to me,
would he? @_@
If he uses count(*) maybe, otherwise he is locking your $.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
the relative value of count my interest was for something
that is even less precise than the usual count but performs better.
I'm not proposing to turn Postgres into MySQL.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 9
returning the same row again).
Could you post a snippet of code or something giving a more detailed
idea of it?
BTW since cursors support offset if you're not interested if the
order of the retrieved rows is random too you don't even have to
remember which one you read I think.
--
Ivan Sergio
Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
but there are a couple of core dev
too that are a bit pissed off about how hard is to support more than 1
DB.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send
thanks to everybody who listened to the call.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's
MUCH more enjoyable.
[1] this is documented... is this aw bw bwaa behaviour of
functions documented as well?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please
On Thu, 17 Jan 2008 19:07:59 -0500
Tom Lane [EMAIL PROTECTED] wrote:
Ivan Sergio Borgonovo [EMAIL PROTECTED] writes:
After discovering that pg_get_serial_sequence behaves in a bit
strange way[1] when it deals to case sensitiveness
The SQL standard specifies that unquoted identifiers
understand and have a case preserving pg.
In reality I'll take more care with quotations and never post after
midnight.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 4: Have you searched our list archives
procedure to return the array as a joined
row?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
weight=subselect._avg
from (
select round(avg(weight)) as _avg
from system where type='module'
) as subselect
where name='users_commerce';
thx
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 3: Have you
to the planner that can then find a better way to
achieve it.
And yeah... on more complex statement the human can make things
worse, writing unnecessary complex sql.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 4: Have you
later. I just would like to have an idea of
the cost of doing it now.
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
the function route was limiting the
number of connections and hiding the underlying structure of the DB
to the client application.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner
writes above can find a tentative place in my mind.
But still then I can't understand where plsql should or shouldn't be
used.
I really would enjoy to see some general guideline on how to chose.
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end
in in forms of
parameters... so a DB abstraction layer or an ORM should help too...
maybe at the cost of some performance.
Otherwise you build up your specialised DB AL that assemble queries
from prepackaged static parts.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
more
comfortable with bcp.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
http://people.planetpostgresql.org/xzilla/index.php?/archives/149-out-parameter-sql-plpgsql-examples.html#extended
Is there any difference in terms of performance and returning rows a
bit at a time between myuser2 and myuser3?
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
;
?
Is there anything else I can do to avoid duplication of code?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Tue, 29 Jan 2008 17:17:39 +
Sam Mason [EMAIL PROTECTED] wrote:
On Tue, Jan 29, 2008 at 06:04:48PM +0100, Ivan Sergio Borgonovo
wrote:
select
case
when (a3) then a*b
when (a3) then a+b
end as pippo
where pippo12;
I've tended to do:
SELECT *
FROM
the syntax further and this is what you'd expect as an output.
Many things are already there in the VI Reference section but some
are not, especially in the V Server programming part.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast
.
I'm a dev not a DBA so I generally don't collect info about
management and tuning.
BTW nice drupal website. I'm looking for a drupal web designer.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 3: Have you
being superuser?
for a Tab delimiter, should i use \t character?
The message should be longer and actually explain what to do.
you can \copy or copy from stdin.
You could find this helpful:
http://www.postgresql.org/docs/techdocs.15
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
be happier ;)
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
?
Are you referring to something like
http://www.postgresql.org/docs/8.1/static/sql-copy.html
or something like:
http://archives.postgresql.org/pgsql-php/2004-02/msg8.php
?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast
...
thanks for your thoughts
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
to retrieve a small number of rows at a time out
of a larger query.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Mon, 11 Feb 2008 08:46:00 -0500
Christopher Browne [EMAIL PROTECTED] wrote:
On Feb 11, 2008 8:04 AM, Ivan Sergio Borgonovo
[EMAIL PROTECTED] wrote:
I did manage to find an announcement about the support of pg for
windows... but I wasn't able to see anything you'd have a summary
with a very bland commitment to the release
schedule it could help developers to build up their own schedule and
support list too and give some hook for advocacy as well.
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast
I did manage to find an announcement about the support of pg for
windows... but I wasn't able to see anything you'd have a summary of
scheduled and planned EOL for various pg versions (on different
platform).
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end
.
Many people aren't used to pg culture and community and oral
knowledge of postgresql.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
On Tue, 12 Feb 2008 16:15:23 -0300
Alvaro Herrera [EMAIL PROTECTED] wrote:
Ivan Sergio Borgonovo wrote:
Is it just vaporware... maybe... but still there are pros and
cons of having a bland schedule for EOL and new releases.
We do have a schedule:
http://developer.postgresql.org
they still deserve a more prominent
place and a less spread distribution.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Tue, 12 Feb 2008 11:19:19 -0500
Andrew Sullivan [EMAIL PROTECTED] wrote:
On Tue, Feb 12, 2008 at 09:44:30AM +0100, Ivan Sergio Borgonovo
wrote:
That's why I wrote without making it too formal and bland
commitment to the release schedule
The problem with doing it that way
Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
problems?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
shop_commerce_paytypes
pt on pm.TypeID=pt.TypeID where b.BasketID=3
I don't even know if it is worth to optimise the above till I'll have
a working comparison.
thx
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
On Wed, 12 Mar 2008 11:48:24 +0100
Martijn van Oosterhout [EMAIL PROTECTED] wrote:
On Wed, Mar 12, 2008 at 11:40:18AM +0100, Ivan Sergio Borgonovo
wrote:
I'd like to make this query work
select 1,
st.Name, sm.Name, sm.MethodID, sm.Description,
pt.Name, pm.Name, pm.MethodID
of performance...
I just would like to be contradicted and pointed to some viable
(easy?) setup for pgsql, so that I and other people will get rid of
this preconception if any.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
- something that won't suffer too much for replicating writes
At a first sight it looks as if pgpool can't boost stuff in pl*
functions.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
On Wed, 12 Mar 2008 10:26:21 -0700
Scott Marlowe [EMAIL PROTECTED] wrote:
On Wed, Mar 12, 2008 at 10:15 AM, Alvaro Herrera
[EMAIL PROTECTED] wrote:
Ivan Sergio Borgonovo wrote:
On Wed, 12 Mar 2008 09:13:14 -0700
paul rivers [EMAIL PROTECTED] wrote:
For a database of InnoDB
data
coherent and sane without doing tons of bookkeeping?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to etch and
sarge won't have sec support at the end of this month.
I'll think it twice before I buy a Dell/LSI controller next time.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
a more informed opinion.
I'd say: 1) legacy 2) no particular interest in data
integrity/coherence
Something more here
http://www.postgresql.org/about/casestudies/
and a bit updated would help too.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql
be interested in
coherency/integrity... just on HA etc...
Still I'd be curious to know if people can scale pg to several
hundreds(?) machines without loosing the features that differentiate
it from other DB...
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list
records _qty and _ItemID are empty
select * from BasketItems(2);
this returns what's expected:
select _ItemID as __ItemID, _qty as __qty from BasketItems(2,null);
What's wrong?
Any way to fix it keeping the names of the returned columns
consistent?
--
Ivan Sergio Borgonovo
http
1 - 100 of 520 matches
Mail list logo