Jonathan Ellis wrote:
: > Also, what happens if the specified length is less than zero? Error,
: > or is it treated as zero?
:
: SQL> select ':' || lpad('abcd', -1, 'foobar') || ':' from dual;
:
: ':
: --
: ::
:
: (colons added so it's obvious that it's a zero-length string)
Returns not empty
Hello, Can anybody check and confirm(or not) this:
if pgsql(DEVEL, from cvs-server) is built with locale and multibyte then
"select * from table where row ilike '%a%'" crashes pgsql.
"select * from table where row ilike 'a%'" doesn't craches.
"select * from table where row like '%a%'" doesn't
Has anybody collected information about what people use Postgres how and
to do what? I think it would be interesting to see where our Collective
got its roots.
Personally, I came from a PHP background using MySQL. An eCommerce (oh, I
hate that word) project stretched the limits of MySQL and Pos
Hi all,
I know this has been discussed before, but I could not find a resolution. Is
it possible to build PostgreSQL 7.x.x for Mac OS X? I'm interested for my
own server, but I've also got a potential client who would be interested.
Seems like it should work without too much fuss. It already runs
To many thanks for the helpfull info.
My brief is::
(1) fix FileMaker for the forseable future
(2) Look at alternatives.
At the moment nothing beyond that is determined.
Apple moving to OSX may change availability of some clients
So I'm looking at all suggestions but not rushing.
Furhter sug
Adam Haberlach wrote:
>
> On Thu, Dec 07, 2000 at 07:27:08PM -0800, Joel Burton wrote:
> > > Given UNIONs are not implemented within views in 7.0.3, what are
> > the
> > > generally suggested work-arounds, if any?
> >
> > Ick. We just did the full SELECTs all the time. A pain.
> >
> > FYI, this i
On Thu, Dec 07, 2000 at 07:27:08PM -0800, Joel Burton wrote:
> > Given UNIONs are not implemented within views in 7.0.3, what are
> the
> > generally suggested work-arounds, if any?
>
> Ick. We just did the full SELECTs all the time. A pain.
>
> FYI, this is fixed in 7.1. Beta Real Soon Now.
Given UNIONs are not implemented within views in 7.0.3, what are the
generally suggested work-arounds, if any?
Regards,
Ed Loehr
> Given UNIONs are not implemented within views in 7.0.3, what are
the
> generally suggested work-arounds, if any?
Ick. We just did the full SELECTs all the time. A pain.
FYI, this is fixed in 7.1. Beta Real Soon Now.
--
Joel Burton, Director of Information Systems -*- [EMAIL PROTECTED]
Suppor
On Thu, Dec 07, 2000 at 03:40:00PM -0600, some SMTP stream spewed forth:
> Ok, so I'm not sure why this is the way it is, but I figured out why the backend was
>failing every time I tried to change the data on the existing five tables. When I
>dropped the five unused tables, I assumed that the
Hello again,
I finally got the Mandrake 7.0.3 rpm installed but it apparently is
missing some files. There is no startup file in /etc/rc.d/init.d and I
cannot find initdb anywhere. I'm not sure where to go from here. In my
old installation (Mandrake Linux 6.5) I down loaded the package and
instal
Disregard my previous; Egg on my face - I had not installed the server!
No wonder there were no executables.
John
begin: vcard
fn: John Pilley
n: Pilley;John
org:Settlement Plus, Inc.
adr;dom:232 E. Lyons;;;Spokane;WA;99208;
email;intern
On 7 Dec 2000, at 1:59, Adam Haberlach wrote:
> I'm looking for a generalized way to set a field to 'now'
> whenever a record is updated.
>
> First, I started creating a plpgsql function for each table that
> I needed this for, and then using a trigger.
>
> Later, I realized that the functions
"Michael Miyabara-McCaskey" <[EMAIL PROTECTED]> writes:
> I fumbled around for a while, but finally recreated table3 as (oid, text,
> text), and it worked fine... My question what caused the backend to crash?
> The data I was inserting into table3, was the actual oid from table2, column
> 2 and c
Soma Interesting writes:
> Documentation on multi-byte and locales support seems to be lacking in the
> postgreSQL site - anyone have any information on this?
http://www.postgresql.org/devel-corner/docs/postgres/charset.htm
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e
Ok, so I'm not sure why this is the way it is,
but I figured out why the backend was failing every time I tried to change the
data on the existing five tables. When I dropped the five unused tables, I
assumed that the DROP function would also remove the foreign key constraint
triggers that
Hello all,
I have been experiencing a strange problem.
I did a import into "table1", and for the sake of not having complaints, all
fields are set to "text". I then created a "table2" again with all types
set to text, and inserted a distinct set of the records from table1 into
table2. No probl
Documentation on multi-byte and locales support seems to be lacking in the
postgreSQL site - anyone have any information on this?
Thanks.
On Thu, Dec 07, 2000 at 10:40:34AM -0200, Vilson farias wrote:
> Lets suppose I have a table with 1000 lines. I'd deleted 900 lines and after
> this I'd done a vacuundb. The question is : The file that contains this
> table will have its size reduced or I'll see no size changes?
By lines, I assum
John Pilley writes:
> Trying to install the RPM for Mandrake, I get a dependency problem:
> libreadline.so.4.1 was not found. Could someone let me know where to get
> it?
>From the readline package, which is on your CD or an ftp mirror near you:
http://www.linux-mandrake.com/en/ftp.php3
--
Pet
20 matches
Mail list logo