Hello All,
This is my first post (so be gentle with me)...
Is there a searchable archive?
I would like suggestions and examples of adding SQL-92
data type BIT compatibility to a PostgreSQL schema.
>From the doc's I gather you can "CREATE TYPE bit"
with storage int or int4... but I don't know
a
Josh Berkus wrote:
>
>
> The solution to this is not to use BLOBs, but rather to use file system
> handles for the location of the binary data on the server. This way,
> all you need is DOS-to-UNIX and UNIX-to-DOS translation for the
> filesystem handles, something easily accomplished through
>
Is DROP Column implemented in 7.x?
Keith
PostgreSQL 6.4 seems to have limitations in Query Length when I
"CREATE VIEW" ... is this limit defined
further, when I create a query on a query... it seems to compound
the queries and reach the limit sooner!!
Is this limit programmable?
Is it default higher in 7.0?
What is the most stable
Is it possible (feasible) to create an index on a view.
We have a large table and a defined sub-set (view)
from this table, would it be possible to keep an index
of the sub-set.
Keith
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Richard Huxton wrote:
>
> Indexes on underlying tables should be used though. Difficult to suggest
> what indices you might need without knowing the view/tables/queries
> involved.
As an example I may have an "Invoice" table with several thousand invoices.
I could design a query/view "Aged" to g
set code = 'O''SHEA' where clientid = 2;
Is it possible to get/configure PostgreSQL to handle
as within a dleimited string?
Keith Gray
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Tom Lane wrote:
>
> Keith Gray <[EMAIL PROTECTED]> writes:
> > Is it possible to get/configure PostgreSQL to handle
> > as within a dleimited string?
>
> We already do.
>
> regression=# select 'O''SHEA';
> ?column?
> --
> > > Is it possible to get/configure PostgreSQL to handle
> > > as within a delimited string?
> >
> > We already do.
> >
>
> This may be a problem in "ipgsql" then??
> ...or is it different in update from select?
The problem is in ipqsql...
it doesn't handle update, but does handle select.
Roberto Mello wrote:
>
> What the heck is ipsql??
>
> -Roberto
ipgsql
A Win32 client for interactive Postgres session
Keith
README
Interactive PostgreSQL presents comfortable windows environment
to execute sql queries, edit tables data, view tabl
named table] into droptemp;
drop [named table];
select * from droptemp into [named table];
Would this be available or easily written as a "rule" ??
Could anyone familiar with the code comment?
--
Keith Gray
---(end of broadcast)---
TIP 5
suggestions would be welcomed (including upgrades)
--
Keith Gray
Technical Development Manager
Heart Consulting Services P/L
mailto:[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org
The install for PgAdmin wont run without MDAC 2.5??
MDAC 2.5 is installed as part of an upgrade(?) to
Internet Explorer 5.5
I have IE5.5 but cannot install PgAdmin.
What is the exact dependency?
Can I force an Install?
--
Keith Gray
Technical Development Manager
Heart Consulting Services
obviously a bit simplistic in my approach.
--
Keith Gray
Technical Development Manager
Heart Consulting Services P/L
mailto:[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Josh Berkus wrote:
>
> To help remedy this, ...
> Can anyone suggest something?
>
Could we set-up a forum with a product like Request Tracker
where a group of experienced users could take questions
from a web-based queue?
--
Keith Gray
Technical Development Manager
Heart Consult
ower(name) = 'jason';
>
How would PostgreSQL know to use the index
MyTable_lower_idx when I do a ...
SELECT * FROM MyTable WHERE lower(name) LIKE 'jas%';
--
Keith Gray
Technical Development Manager
Heart Consulting Services P/L
mailto:[EMAIL PROTECTED]
.description, stock.available
FROM item, stock
WHERE item.itemid = '1234'
AND item.itemid=stock.itemid;
...would be more efficient than,
SELECT item.description, stock.available
FROM item, stock
WHERE item.itemid=stock.itemid
AND item.itemid = '1234';
--
Keith Gray
Technical S
d the
> names at which point you should always use double quotes to refer
> to it (yes, if the name was "foo" you *can* refer to it as foo, but
> you really shouldn't).
Your table names are case sensitive.
PostgreSQL will make them all lowercase by defa
We have moved from 7.1 to 7.2 and get the following error when
extracting dates.
Bad timestamp external representation ' '
eg. INSERT INTO mytable VALUES('1', '2001-09-24')
Seems to accept dd/mm/
(What about ISO default?)
--
Keith Gray
Technical Ser
Josh Berkus wrote:
>>But EXISTS is an entirely different animal which is often faster
>>... isn't that in the FAQ?
There is no reference to EXISTS in the SELECT documentation??
Is this explained somewhere else?
--
Keith Gray
Technical Services Manager
Heart Co
neous lookup?
--
Keith Gray
Technical Services Manager
Heart Consulting Services
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
rapped in a VB6 ADO ODBC program.
Is this likely to be sorted in 7.2 ?
Is anyone looking at this?
--
Keith Gray
Technical Services Manager
Heart Consulting Services
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
L work around?
Can I help this to happen?
--
Keith Gray
Technical Services Manager
Heart Consulting Services
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
23 matches
Mail list logo
