sequences - Search results in mailing lists

2024-12-16 13:21:03 | Abitity to identify the current iteration in a recursive SELECT (feature request) (sulfinu@gmail.com)

sequence, which is cumbersome because; - the sequence is single-use, so it must be named

2024-03-13 04:38:09 | Can portals interleave with other portals (Evgeny Smirnov)

sequence for another prepared statement and portal (lets say B_2) but without a limit

2024-02-21 22:06:55 | How to find all current sequence IDs (Campbell, Lance)

sequences, the schema it is used in, and the current sequence number in use? The below

2023-02-25 21:56:27 | Re: Take the data from table and rotate the member on every 7th day or (Steve Midgley)

sequence that is, in this case modulus 5? I'm not sure I've got the SQL skills

2022-09-16 07:51:54 | Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12 (Inzamam Shafiq)

sequence you give here doesn't fail for me. However, this table has three different

2022-03-09 08:26:30 | Re: Best practice for naming temp table trigger functions (Sebastien Flaesch)

sequence seems to do the job... Just need confirmation that this is valid PostgreSQL code

2022-03-05 08:51:08 | Re: Bug in tables column data in postgres database (David G. Johnston)

consequences. But repeating the exact same emails will not magically result in a different outcome

2021-10-13 07:03:45 | Re: Fault with initcap (Pavel Stehule)

sequence of alpha numeric chars. "'" is not alpha numeric char. Theoretically it can work if you use ICU collation

2021-08-05 14:04:24 | Sv: Like Command returning wrong result set (Andreas Joseph Krogh)

sequence of zero or more characters. * Underscore sign ( _) matches any single character. -- Andreas Joseph Krogh

2021-08-03 15:40:03 | How to generate the order if you know the next item for each item? (Rockdale Green)

sequence number, can I do it in one query? Table task id name 1 postoffice

2021-03-31 14:57:57 | Re: Serial sequence name when table/column name in uppercase (Sebastien FLAESCH)

sequence name just from the table name. The sequence name will then be used to automatically

2021-01-14 16:26:55 | Non blocking type change for primary column (Torge Kummerow)

sequence to the new column and deattach it from the old column 5. Make new column

2020-12-02 15:25:37 | parallel safe on user defined functions (Voillequin, Jean-Marc)

sequences, change the transaction state even temporarily (e.g., a PL/pgSQL function which establishes an EXCEPTION

2020-11-20 08:19:57 | Re: Get last generated serial sequence and set it up when explicit value is used (Sebastien FLAESCH)

sequence. In particular, the last_value field of the sequence shows the last value allocated

2020-11-18 17:43:12 | Querry correction required (Sachin Kumar)

SEQUENCE_NUMBER" ORDER BY h."id" ) AS v WHERE m."CARD_SEQUENCE_NUMBER" = v."CARD