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
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
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
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
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
memories of how to tweak with ubuntu's locales.
Differently from Debian doing
dpkg-reconfigure -plow locales won't help
You had to do it manually.
here are the explanation on how I did it
http://www.webthatworks.it/drupal/2006/09/general/generating_new_locales_in_ubuntu_kubuntu_co
--
Ivan Sergio
plpgsql;
thx
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
(that should be ready before I'll finish my pgsql project).
Anyway I'm quite conservative in administrative related stuff... since I'm not
a sysadmin and I don't want to rely on anything that gives me a feeling of not
being under my control.
On Sep 11, 2006, at 8:34 AM, Ivan Sergio Borgonovo
: 2006-09-09 21:25:06.947069
Is there any way (even somehow through the ODBC driver) to restrict
the timestamp accuracy to M$ Win accuracy?
http://www.postgresql.org/docs/7.4/static/functions-datetime.html#FUNCTIONS-DATETIME-TRUNC
???
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
column + an
int?
create table f (
ab int,
aorb boolean,
);
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Tue, 5 Sep 2006 22:53:14 +0200
Ivan Sergio Borgonovo [EMAIL PROTECTED] wrote:
Hi,
The most general problem that may be a design problem (and I'm not
asking to do my homework even if well, you may still help g) is
I've a temporary relation and a permanent relation. A typical
situation
to understand if there is a way to exploit TG_ARGV[] Co. but I
didn't understand even how to use it.
BTW postgres is 7.4.13
thx
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 4: Have you searched our list
I'd like to do something like
grant all on * to username;
on a whole database, where * are tables, sequences etc...
is there any shortcut?
thx
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send
On Mon, 10 May 2004 13:56:39 -0500 (EST)
Kris Jurka [EMAIL PROTECTED] wrote:
On Mon, 10 May 2004, Ivan Sergio Borgonovo wrote:
Now let's come to the problem:
create or replace function testa( )
returns char(32) as
'
begin
if 1=2 then
if 1=2
I can't understand how to pass strings to functions.
create type tSession
as
(
SessionCode char(32),
SessionID char(32),
UserIDI integer,
SessionN integer
);
create or replace function GetSessionCode( char(32), smallint,
boolean, varchar(128) ) returns tSession as
'
declare
what's wrong with this?
create type tSession
as ( ty_found boolean, ty_Session char(32) );
create or replace function GetSessionID( integer )
returns tSession as '
declare
thisSession tSession;
begin
--HERE!!!
thisSession := ( ''t'', md5( now( ) || rand( )
On Tue, 27 Apr 2004 10:12:13 -0700
Ron St-Pierre [EMAIL PROTECTED] wrote:
Ivan Sergio Borgonovo wrote:
--HERE!!!
thisSession := ( ''t'', md5( now( ) || rand( ) ) );
- md5 takes TEXT as an argument, not a numeric type
Since it works you surely fixed my code but this should't
I'd like to compute some row like results and return them from a
function (and pass the result to PHP[*]).
Well I've read about composite type but all the references I've seen
are about coding in C. That's not the way I'd like to follow by now.
I was expecting to declare composite types in
501 - 520 of 520 matches
Mail list logo