I wanted to ask this on here before going any further.
I've got functions that return rowsets, which from the psql shell require
me to write selects with AS TBL( ... ) to define the return types.
When I try to put a query together in ECPG to get values from these
functions, I discovered some nast
Hello Melanie
If your set of items will by static and small, then you can use CHECK
constraint. I use it for five, items itemes.
You can write more simple this constraint
...
user_type TEXT NOT NULL CHECK (user_type IN ('Root','Admin','Standard')),
regards
Pavel Stehule
On Mon, 22 Dec 2
Oleg
You has true. After restart of postmaster all works fine.
tsearch2=# select to_tsvector('default_czech','Jmenuji se Pavel Stěhule');
to_tsvector
'pavel':3 'stěhule':4 'jmenovat':1
Thank You very much
Pavel Stehule
On Mon, 22 Dec 2003, Ole
On 23/12/2003 21:46 CSN wrote:
Is is possible to find out what options (prefix,
bindir, etc.) were specified to "configure" when
Postgres was built?
pg_config --configure
HTH
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limit
The queries are listed here for the referentially (yes that's a pun)
challenged.
Query 1:
SELECT COUNT(message_id)
FROM messages m
LEFT JOIN accounts a
ON m.account_id::bigint = a.account_id::bigint
WHERE a.email = '[EMAIL PROTECTED]';
Query 2:
SELECT COUNT(message_id)
FROM accounts a
> Hey list, I'm just wondering if anyone can point me in the direction of a mirror
> that doesn't suck.
At least in the US, I think I should be pretty decent
(ftp3.us.postgresql.org). I've rate limited down to 6M/s but that should
be enough for anyone. I rsync every 4 hours. If anyone can't
On Mon, Dec 22, 2003 at 09:10:43 -0800,
Michael Gill <[EMAIL PROTECTED]> wrote:
> How can I hide all details from users regarding data and structure,
> limiting access to data through functions I create?
>
> I don't want a user to be able to see the structure of a table with \d
> {tablename} in
On Tue, Dec 23, 2003 at 22:04:56 -0600,
Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> On Mon, Dec 22, 2003 at 09:10:43 -0800,
> Michael Gill <[EMAIL PROTECTED]> wrote:
> > How can I hide all details from users regarding data and structure,
> > limiting access to data through functions I create?
DeJuan Jackson <[EMAIL PROTECTED]> writes:
> Query 1:
> SELECT COUNT(message_id)
> FROM messages m
> LEFT JOIN accounts a
>ON m.account_id::bigint = a.account_id::bigint
> WHERE a.email = '[EMAIL PROTECTED]';
> Query 2:
> SELECT COUNT(message_id)
> FROM accounts a
> LEFT JO
Hello
I have postgresql latest version running on RH 9. I
want to write a windows based application to interact
with postgresql server. For that I plan to use libpq
i.e. using C.
I can work with the linux version but try as I might I
am not able to locate a source for compiled ( static )
version
10 matches
Mail list logo
