Is it possible to use the statements INNER JOIN, OUTER JOIN, LEFT JOIN
and RIGHT JOIN in the new version of PostgreSQL 7.1 ?
Luis Sousa
>From pg_group, it's possible to return the users that are in that group.
How can in put the values in that array of integer to an array ??
Using plpg/SQL, how can i access to the array of integers ???
Best Regards
Luis Sousa
---(end of b
fields in the view so it could be possible
to restrict that data
Best Regards
Luis Sousa
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
of you How can i do this
Thanks
Luis Sousa
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hello
I have a function with a field record named 'starting'.
Now I want to use starting in a query. Is it possible ?
I use it with a simple join inside the query a I got the message that
table starting is not defined !!!
Best Regards
Luis Sousa
---(end of
But I got permission denied on those
tables.
The idea was to create a layer, with the views, giving to that user
permission on views to insert and update, and not to tables.
Is this possible ?
Thanks in advance.
Luis Sousa
smime.p7s
Description: S/MIME Cryptographic Signature
!! (those
operations that are executed on rules)
Luis Sousa
smime.p7s
Description: S/MIME Cryptographic Signature
t the only way to do it ?
Luis Sousa
smime.p7s
Description: S/MIME Cryptographic Signature
See the online docs, under Server Programming, for how to use the RULES
system.
That's what I already made. The problem is when I do the update, I
permission denied in all the tables for update and insert. The user
that's making this operation only have select privilege.
Any way
quot;=1:
-- Rule definition
CREATE RULE "pessoalInfo_r_insert" AS ON INSERT TO "pessoalInfo_v"
DO INSTEAD (
INSERT INTO pessoal (titulo,nome)
VALUES (NEW.titulo,NEW.nome);
INSERT INTO "pessoalGabinete" ("idPessoal",edificio,sala)
VALUES (1,
Tom Lane wrote:
Luis Sousa <[EMAIL PROTECTED]> writes:
When inserting, using the rule, the insert that's defined on the rule
works fine, but the insert defined inside the function, doesn't (that's
the one that gives permssion denied).
Right. As of 7.3 you can f
Hi there,
I'm using debian woody. If you post your configuration files that are in
/etc/postgresql/ maybe i can help you.
Regards,
Luis Sousa
Hugh Esco wrote:
Hey folks:
I am able to consistently start and stop the postgreSQL server and to
access it across our office network with pgAdm
m lane
I agree with Tom Lane. Probably is the best thing to do. When you
install all it over, in theory, all the problems will solve by them selfs.
Luis Sousa
smime.p7s
Description: S/MIME Cryptographic Signature
again dpkg --purge.
Luis Sousa
Hugh Esco wrote:
I have reinstalled before. I wonder though, how I ensure that I have
cleanly un-installed it first, so that I leave no residue from the
previously botched installation around to mess things up the next time.
-- Hugh Esco
At 09:03 AM 11/19/02
biko:/usr/bin# psql -U postgres
No database specified
Instead, do: su - postgres
Then do: psql template1 or psql -h template1
My pg_hba.conf temporarily reads:
local all trust
host all 127.0.0.1 255.255.255.255 trust
host template1 192.168.2.21 255.255.255.0 trust
For now, just remove
When I do an 'INSERT INTO VALUES '
and on the table is a serial primary key named p_key.
As I want this number to be auto-generated, but use it as a 'customer
number', I want to create this function to return the value of this
insert.
Try this:
SELECT currval();
Luis
Tell me what did you try with limit and group by.
Where's IN, why don't you use EXISTS instead. It runs much master !
Regards,
Luis Sousa
Arcadius A. wrote:
Hello!
I hope that someone here could help.
I'm using PostgreSQL7.1.3
I have 3 tables in my DB: the tables are
Can you post the recursion function that you use on this case to get out
the information from the table ?
Thanks,
Luis Sousa
Stefano Vita Finzi wrote:
Greetings!
I have a table like:
node parent
1 2
2 3
3 4
Since i traverse this table with a recursive function, i want to
Hi all,
How can I set a function as setuid ?
I take a look at the documetation, on Reference Manual and the only
reference I saw to it was on SET SESSION AUTHORIZATION.
Thanks in advance.
Luis Sousa
---(end of broadcast)---
TIP 4: Don't &#x
analyze is your friend
Did you already tried dia?
I never used it, but someone told me that imports data definition from
PostgreSQL. You can try it.
Luis Sousa
smime.p7s
Description: S/MIME Cryptographic Signature
0
Here, the age between 2004-05-26 16:00 and 2004-02-18 16:00 is 3 mons 8
days, and this interval added to the initial date gives the correct result!!
Best regards,
Luis Sousa
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
I worked around this problem returning the difference between the two
dates, using extract doy from both.
Anyway, this will cause a bug on my code when changing the year. Any ideas?
Best regards,
Luis Sousa
Tom Lane wrote:
Theodore Petrosky <[EMAIL PROTECTED]> writes:
wow at f
Yes, that's a much more clever solution than the one I used.
Thanks
Best regards,
Luis Sousa
Alexander M. Pravking wrote:
On Mon, Jul 19, 2004 at 10:00:50AM +0100, Luis Sousa wrote:
I worked around this problem returning the difference between the two
dates, using extract doy from both.
A
ar "ON" at character 60.
Thanks in advance for you answers.
Luis Sousa
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
24 matches
Mail list logo
