Lucazeo <[EMAIL PROTECTED]> writes:
> It seems that ("inDate" IS NULL) never returns true, even when the
> parameter is null...
Exceedingly unlikely.
> What's wrong?
You have not provided enough context for anyone to guess.
regards, tom lane
--
Sent via pgsql-general m
I have a strange problem with the following condition in a SELECT:
AND (("TableData" = "inDate") OR ("inDate" IS NULL))
it works perfectly when the input date in the function (inDate) matchs
a date in the table, but it does not work when the parameter inDate is
NULL.
I recall the function with pga
I need to "glue" codes to "concatenate" them as a single lexeme to
other tsvectors in a way that a code won't be split but will remain
one lexeme.
eg. if input is "ab12 456/z7_92$44'a37" I don't want it get parsed
into
{ab12} {456} {z7} {92} {44} {a37}
but I want to keep the highest possible numbe
Grzegorz Jaśkiewicz wrote:
how about windows task scheduler ? (cron-ish thing)
If the OP wants to do the exact same insert every minute, then the OS
scheduler sure does the job.
That's not how I understood the question, though. My interpretation is
that he has a SQL script with an
Roberto Scattini wrote:
in a couple of days i will reinstall an offline database server. It's
a old HP Proliant DL580 G3 with three disks (147 GB each). Currently
it has a debian Sarge in a RAID5 hardware array ( with HP Smart Array
6i, [RAID bus controller: Compaq Computer Corporation Smart Arr
how about windows task scheduler ? (cron-ish thing)
>
> --
GJ
searchelite wrote:
I have an sql script consists of insert statement data. I want to
insert
every row of data every one minute. How can i do that using batch
file in
windows
How about using pg_sleep ?
INSERT ;
COMMIT;
SELECT pg_sleep(60);
INSERT...;
COMMIT;
SELECT pg_sleep(6
Hmm... seems like a SNAFU on my part.
I didn't know that I need to execute it using EXECUTE SCRIPT via slonik.
I was doing it via pgadmin & psql.
Reading this :
http://lists.slony.info/pipermail/slony1-general/2008-October/008929.html
and trying it found the issue.
Thanks and sorry for the noi
Quoted from
http://www.nabble.com/Group-Sets-For-Replication-w--Partition-d19369646.html
> Basically, what you would need to do, weekly, is to run a slonik
> "execute script" script where the SQL script consists of something
> similar to what's in tests/testpartition/gen_ddl_sql.sh:
> -> crea
