(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 a
> 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 testt
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 plan
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 th
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 [EMAIL
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, Gowe
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 gouppertable_co
> 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();"
This sets the seed for the random() function.
However, the approach we use is more like the
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 PROT
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 a
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 from-s
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
»úÃÜ ÉîÛÚÊзçÁÖ»ð
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 broadcast)--
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
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 b
"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 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 I'm hesitant to
>
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,
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
[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 Journ
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 PROTECTED]]
31 matches
Mail list logo
