; foo.bar = NULL". Is it because NULL does not "equal" any value, and the
> expression should be read as "foo.bar is unknown"? Or is there something
> else I'm missing?
As far as I have been able to tell, it is one of those quirks about SQL that
you shouldn'
EmailAddress;
ERROR: Cannot cast type character varying to cstring
Does anyone have any suggestions on how I could accomplish the above?
--
/* Michael A. Nachbaur <[EMAIL PROTECTED]>
* http://nachbaur.com/pgpkey.asc
*/
...[Arthur] leapt to his feet like an aut
On Tuesday 25 November 2003 09:09 am, Tom Lane wrote:
> Michael A Nachbaur <[EMAIL PROTECTED]> writes:
> > scamp=> select * from Dialup.UserGroup;
> > ERROR: dialup: permission denied
>
> You haven't granted USAGE permission on the "dialup" schema
ema to be owned by the "dialup"
user. Could this perhaps be causing some problems?
Any help on the matter would be appreciated (or getting the mailing list
archives website up and running again ;)
--
/* Michael A. Nachbaur <[EMAIL PROTECTED]>
* http://nachbaur.com/pgpkey.asc
*
On Thursday 25 September 2003 05:06 pm, Manuel Sugawara wrote:
> Michael A Nachbaur <[EMAIL PROTECTED]> writes:
> > b) is there a better and/or faster way of implementing this? I
> > don't want searches to bog down (at least too badly) as a result of
> > thi
my ($source) = @_;
$source =~
tr/áàâäéèêëíìîïóòôöúùûüÁÀÂÄÉÈÊËÍÌÎÏÓÒÔÖÚÙÛÜ//;
return $source;
' LANGUAGE 'plperl';
--
/* Michael A. Nachbaur <[EMAIL PROTECTED]>
* http://nachbaur.com/pgpkey.asc
*/
"Ah, " said Arthur, "this is obvi
urrID;
but that seems like a big hack. While this would force the alias' triggers to
run, it seems to me that there should be a cleaner way of doing this.
Suggestions, anyone?
--
/* Michael A. Nachbaur <[EMAIL PROTECTED]>
* http://nachbaur.com/pgpkey.asc
*/
`I am so amazingly cool
On Wednesday 09 July 2003 02:28 pm, Cliff Wells wrote:
> On Wed, 2003-07-09 at 14:14, Michael A Nachbaur wrote:
> > So, I'm looking at syncronizing 4 tables from one master database to
> > several child databases. I'm thinking of doing the following with
> > DBD:
rent may take more effort than simply rebuilding.
What are your thoughts? These tables will probably only have a maximum of
10,000 rows in total, but I'm going to have to syncronize once per minute; as
a result, I wouldn't like this to take any longer than about 10 seconds.
--
/* Michael
Yasir Malik <[EMAIL PROTECTED]>
> > Subject: Re: [SQL] Datatype conversion help
> >
> > On Tue, 2003-07-08 at 15:07, Yasir Malik wrote:
> > > I've tried to_char(in_val, '99'), and that returns a string that is two
> >
> > select to_char(
g that is two
> charecters, but there isn't a leading zero incase I have the number 2 as
> input. Any ideas? Thanks.
> Yasir
>
> ---(end of broadcast)-------
> TIP 7: don't forget to increase your free space map settings
--
n entire tree of data if any one of it's
members dies?
Thanks in advance.
--
/* Michael A. Nachbaur <[EMAIL PROTECTED]>
* http://nachbaur.com/pgpkey.asc
*/
"I don't know, " said the voice on the PA, "apathetic
bloody planet, I've no sympathy at all. "
y table without having to
regenerate the results every time I want to show a "Page 299 of 500" toolbar.
Would I be better off just sucking this data into an in-memory data structure,
or can I use a temp table as an easy-to-use alternative?
--
/* Michael A. Nachbaur <[EMAIL PROTECT
ou're using KDE you might want to look into Umbrello. It's
a UML modelling app for KDE, and is quite good, even has the beginnings of
code generation (for SQL, Perl, Java, etc).
--
Michael A Nachbaur <[EMAIL PROTECTED]>
---(end of broadcast)---
On Monday 23 June 2003 11:16 am, Markus Bertheau wrote:
> В Пнд, 23.06.2003, в 19:32, Michael A Nachbaur пишет:
> > Instead of using the "serial" datatype, you can set it to "int4 PRIMARY
> > KEY DEFAULT nextval(foo_type_id_seq)" and you can manually creat
f?
>
> --
> Markus Bertheau
> Berlin, Berlin, Germany
>
> ---(end of broadcast)---
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
--
Michael A Nachbaur <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
gt; inheritance).
I did something to this effect years ago on an Oracle database, but since I
was just a newbie to SQL, I assumed there had to be a better way of doing
this. :-) Beginners luck?
--
Michael A Nachbaur <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
ow-away script I whipped up to migrate from an older
system, so the code isn't all that clean (e.g. not commented, convoluted
variable names, etc) but it should get you started.
--
Michael A Nachbaur <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
oing a plain-ol'
left outer join across all my inherited service tables?)
Thanks in advance. I'd appreciate any feedback you have to offer.
--
Michael A Nachbaur <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 3: if posting/read
x27;, 'c');
>
> SELECT a, concat(b) FROM (SELECT a,b FROM test ORDER BY a,b) T GROUP BY a;
>
> /*
>
> a | concat
> ---+-
> A | 1,2,3
> B | a
> C | b,c
>
> */
>
> The ORDER BY is included to sort the rows before they are aggregated. I'm
&g
(Target, ',') FROM Aliases
Is there any way this can be done with Postfix?
--
Michael A Nachbaur <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
21 matches
Mail list logo
