Frank Miles <[EMAIL PROTECTED]> writes:
> Seq scan for '=' and for 'LIKE'; no locale support enabling. As Len
> Morgan suggested, it appears to be a matter of LIKE being sensitive to
> trailing spaces, and '=' NOT being sensitive to them. The field data type
> is char(16) {not stated in my origi
Does postgresql has any windows clients(like there is psql for unix
environment) ?if there, where can i download from?
Regards,
Abhi
http://www.postgresql.org/users-lounge/docs/faq.html
---(end of broadcast)---
TIP 1: subscribe and unsubscribe c
> A direct query gets appropriate rows of data:
>
> dbname=# select * from partdef where shpname = 'IDC16W';
> ...while the very same query (substituting LIKE for the '=' sign) gets
nothing!?
>
> dbname=# select * from partdef where shpname LIKE 'IDC16W';
> Can someone please tell me the really
Hi ...
I have been planning using the PostgreSQL database using a somhow large
database (and therefor some large tables). While doing this i really
like to know if it is possible to split data in a database og even a
table between several disks ?
I have tried to look into this problem, and it lo
this is logical flaw in PostgreSQL's psql include file (input.h). I
wrote, but have been told it was ok, and nobody wanted to change it.
Personally i patch every version of PostgreSQL by hand to get readline
edit mode working. Yeah, that sucks...
On Mon, May 21, 2001 at 10:32:37AM -0400, Frank Ba
Is it possible that there are spaces after the 'IDC16W' in the field? Try:
LIKE 'IDC16W%'
and see if that makes a difference.
len
>A direct query gets appropriate rows of data:
>
>dbname=# select * from partdef where shpname = 'IDC16W';
> pn_id | class | num | mt | ver | loc_id | unit_id | s
On Mon, May 21, 2001 at 10:32:37AM -0400, Frank Bax wrote:
> I have a machine with OpenBSD 2.6 and PSQL 6.5.3 that allows the use of
> up-arrow to retreive/edit previous commands.
>
> I recently built a new machine with OpenBSD 2.8 and PSQL 7.0.2 (from
> package) and this feature is GONE!
>
> Is
Running 7.1(.0) on a PC running Debian Linux (potato), I have a strange situation in
psql:
A direct query gets appropriate rows of data:
dbname=# select * from partdef where shpname = 'IDC16W';
pn_id | class | num | mt | ver | loc_id | unit_id | subptcnt | shpname |
value| des
Greets,
I'm trying to get my head around what the benefits to inheritance are.
Is the data duplicated or just referenced in the parent table? If it's
duplicated then the database size and bloat are an issue for me.
Another question I have is that say I have a parent table
I have a machine with OpenBSD 2.6 and PSQL 6.5.3 that allows the use of
up-arrow to retreive/edit previous commands.
I recently built a new machine with OpenBSD 2.8 and PSQL 7.0.2 (from
package) and this feature is GONE!
Is there some way to get this functionality back (hopefully without
changin
On Mon, 21 May 2001 07:55:13 -0400
Andrew Rawnsley <[EMAIL PROTECTED]> wrote:
> If I ever come up with said schema-dropping patch, and anyone else
wants it,
> let me know.
I'd dance a happy jig ;-)
I'm not sure whether it is quite the way to do it, but I'd have a better
time with things if I c
Monday...
I can't get my brain around this one.
Get the top three replies from a quizz.
I want to select from a table all records which have a value of
1.00, 2.00 and 3.00. Then I want to class the records by the
column which has the most 1 followed by the most 2...
Yes I was throw
On 21 May 2001 13:02:21 +, Michelle Murrain wrote:
> Actually, I was going to investigate this for FileMaker - are their
> postgresql ODBC drivers for the mac? I couldn't find any.
M$ ones should work. There is one for 4D ($$$)
Cheers
Tony Grant
--
RedHat Linux on Sony Vaio C1XD/S
http:
Tony Grant wrote:
> Hi,
>
> Does anybody know of any issues with Mac OS 9.x and either AppleWorks or
> Excel and ODBC access to a Postgres backend?
>
> I have a client who needs to print labels and who has AppleWorks.
Actually, I was going to investigate this for FileMaker - are their
postgre
>> I don't know what you are using those database for, but nothing prevents
> >you from letting your clients connect to the different databases the
> >same time.
>But that requires me to make a new database connection for each database I
>need to access.
>And putting 200+ tables in one single
I have a problem with PostgresSQL 7.1 and Micro$oft Windoze ODBC and MS
Access 2000 which I am hoping someone here might be able to help me with.
When I try to link MS Access to a PostgresSQL 7.1 table, Access is unable to
see any of the tables in the database so I cannot select a table to link.
Hi,
Does anybody know of any issues with Mac OS 9.x and either AppleWorks or
Excel and ODBC access to a Postgres backend?
I have a client who needs to print labels and who has AppleWorks.
Cheers
Tony Grant
--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macrom
17 matches
Mail list logo