Thanks Steve!
Just want to get confirmation that postgres does not use any special rules
When no sorting order specified.
Thanks,
Quang.
On 5/30/14 5:20 PM, "Steve Atkins" wrote:
>
>On May 30, 2014, at 5:13 PM, Quang Thoi wrote:
>
>> Any one knows how sorting
Any one knows how sorting works?
I am using postgresql 9.3 and runs on Linux machines.
I see different sorting order for the same set of return data.
On linux machines, databases are configured the same.
Database have encoding set to 'utf8' and locale='C'
query:
Select host_id, host_name from ho
I want to roll back deletion if there is a reference (FK) in another table.
Can I explicitly call a rollback inside a function?
CREATE OR REPLACE FUNCTION pre_del_prod_proc()
returns trigger as $$
begin
if exists (select 1 from host_config where config_id = OLD.id) then
rollba
Hi,
I am trying to port sybase codes to posgresql. I have looked into the
postgresql documentation
but couldn't find good information on how to create an equivalent recurrence
event
which similar to the sybase codes below.
Can some one please help?
sybase codes:
create event PURGE_ORDER sche
