(sorry to reply to a week-old message. need to keep up with this list more!)
On Monday 17 September 2001 17:04, you wrote:
There is an obvious benefit to the use of cursors within a persistent
environment. In other words, if my connection to the database is live, I
can increase my query and
Use kon command.
This was a wonderful tip - thank you, Ishii-san! I didn't know about the
command, and it seems to be trying to do what it is designed to do. It
doesn't display Shift-JIS correctly, but it does work for EUC. Since I seem
to be moving in the direction of converting everything
Use kon command.
This was a wonderful tip - thank you, Ishii-san! I didn't know about the
command, and it seems to be trying to do what it is designed to do. It
doesn't display Shift-JIS correctly, but it does work for EUC. Since I seem
to be moving in the direction of converting
Hi,
does anybody know a way, how to implement the content of a field of type
TEXT
into a query?
if i am trying:
select * from testtable WHERE testTEXT LIKE '%testString%'
i am getting always an empty selection, although there is a record existing.
The same with
select * from
I am wondering whether anyone has already tried it, or if not, looking
for starting points as to how to go about doing it:
The idea would be to have some kind of tree implementation (e.g.
pointers or nested sets) for an SQL database and then to write a Linux
driver that would make it possible to
Hey everyone,
Is there a function out there for pg which allows you to generate a random
number given a seed value? I'm trying to create a users table which would
require the storage of a password in a database field, and I'm hesitant to
put it in there in plain text, despite the fact I
Hmm, filesystem IS database.
If you need SQL-like functionality to ask for something in your fs why do
you want to mount db like fs?
You can build a sql-like shell !?! EnhancedBASH?
JP
On Tue 25. September 2001 14:22, you wrote:
I am wondering whether anyone has already tried it, or if not,
On Tue, Sep 25, 2001 at 02:45:37PM +0200, Jan Pruner wrote:
Hmm, filesystem IS database.
If you need SQL-like functionality to ask for something in your fs why do
you want to mount db like fs?
You can build a sql-like shell !?! EnhancedBASH?
I couldn't possibly explain it any better than
I installed PG from RPMs. postgresql.conf comes with all options commented
out.
What are the defaults? PG works anyway (Well... I know... -i etc.)
Thank you all.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Just wondering if anyone knows off hand how to make it so all inserts on a
column will wind up being tranparently stored as uppercase (ex: ee1234567 =
EE1234567).
Geoff
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to
One turnarround solution I use for that is to make the convertion to
uppercase in the script prior to the insertion. If that is your case, u can
do that too. Nevertheless, it seem easy to make a function toupper(), if it
does not exists yet
On Tue, Sep 25, 2001 at 12:43:58PM -0400,
On Tue, 25 Sep 2001, Gowey, Geoffrey wrote:
Just wondering if anyone knows off hand how to make it so all inserts on a
column will wind up being tranparently stored as uppercase (ex: ee1234567 =
EE1234567).
Probably a trigger, before update/insert on table:
create function
Is there a function out there for pg which allows you to generate
a random
number given a seed value? I'm trying to create a users table
which would
There is the following:
select setseed(new seed value);
This sets the seed for the random() function.
However, the approach we use is more
I want to write a function that finds out whether a function already exists.
Is that possible? How?
Thank you all.
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL
I created 2 functions: f1 and f2. f1 calls f2. I then change f2.
What is the minimum I need to do for f1 to see the modified f2?
Is my understanding correct that I need to drop and recreate f1?
Thank you in advance.
---(end of broadcast)---
TIP 4:
Can anyone out there help me.
I have created a trigger and can't get it to run.
When it is invoked I get a compile error no matter what.
.I have changed the code in the trigger many times and it really doesn't
matter what the code actually does it still won't compile.
I have stripped it down so
On Tuesday 25 September 2001 11:34 am, Mihai Gheorghiu wrote:
I installed PG from RPMs. postgresql.conf comes with all options commented
out.
What are the defaults? PG works anyway (Well... I know... -i etc.)
Thank you all.
All options commented out is the installation default of a
Let's say I have a table :
create table people (
person_id integer not null primary key,
firstnames varchar(50),
lastname varchar(50)
);
and another
create table partners (
first_person integer not null references people(person_id),
second_person integer not null reference people(person_id)
);
Sorry for test post.
lt ss 9/26/2001
»úÃÜ ÉîÛÚÊзçÁÖ»ðɽµçÄÔ¼¼ÊõÓÐÏÞ¹«Ë¾ µÚ1Ò³/¹²1Ò³
Hi,
Well i have seen somewhere
WHERE somefiled @ '{123,324}'
what does this mean
Sameer
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
---(end of
I have designed a trigger that will insert a row
in a table if a check to see if the row is already there fails.
Everything works as expected when running slow or with few threads.
but when I kick up the threads that handle the initial insert that
'triggers' the trigger I run into some trouble.
Micah Yoder wrote:
(sorry to reply to a week-old message. need to keep up with this list more!)
On Monday 17 September 2001 17:04, you wrote:
There is an obvious benefit to the use of cursors within a persistent
environment. In other words, if my connection to the database is live, I
Mihai Gheorghiu wrote:
I created 2 functions: f1 and f2. f1 calls f2. I then change f2.
What is the minimum I need to do for f1 to see the modified f2?
Is my understanding correct that I need to drop and recreate f1?
Thank you in advance.
For functions called by functions, it should be
Gowey, Geoffrey [EMAIL PROTECTED] writes:
Just wondering if anyone knows off hand how to make it so all inserts on a
column will wind up being tranparently stored as uppercase (ex: ee1234567 =
EE1234567).
Sounds like a good application for a trigger.
-Doug
--
In a world of steel-eyed
On Tue, Sep 25, 2001 at 08:42:04AM -0400,
Mike Arace [EMAIL PROTECTED] wrote:
Is there a function out there for pg which allows you to generate a random
number given a seed value? I'm trying to create a users table which would
require the storage of a password in a database field, and
On Tue, Sep 25, 2001 at 02:20:23PM -0400, Mihai Gheorghiu wrote:
I want to write a function that finds out whether a function already exists.
Is that possible? How?
select * from pg_proc where proname = ??;
you can run psql with switch -E, then it shows intenal queries
it performs. Eg., for
Colin 't Hart [EMAIL PROTECTED] wrote in message news:9oo6en$qr8$[EMAIL PROTECTED]...
August Zajonc:
I tend to follow the mailing list through news.postgresql.org, and it
seems
like all the -hackers messages are ending up in the .general group rather
than .hackers.
I also follow the
[EMAIL PROTECTED] writes:
Can anyone out there help me.
I have created a trigger and can't get it to run.
When it is invoked I get a compile error no matter what.
.I have changed the code in the trigger many times and it really doesn't
matter what the code actually does it still won't
I am wondering whether anyone has already tried it, or if not, looking
for starting points as to how to go about doing it:
I recall seeing an article in a magazine a couple of years ago by
someone using PostgreSQL to implement a versioning file system on Linux.
I *think* it was in Linux
I wasn't sure about the quotes and have taken
them off ( didn't have them in the beginning )
but the problem still exists.
I was just looking at other trigger code and was
wondering if maybe I need a ; after the last END?
-Original Message-
From: Doug McNaught [mailto:[EMAIL
30 matches
Mail list logo