On Feb 6, 2014, at 12:57 PM, Gavin Flower wrote:
On 07/02/14 05:43, Michael Sacket wrote:
On Feb 6, 2014, at 2:23 AM, Vik Fearing wrote:
On 02/06/2014 04:16 AM, Michael Sacket wrote:
Often times I find it necessary to work with table rows in a specific,
generally user-supplied order. It
On 02/06/2014 04:16 AM, Michael Sacket wrote:
Often times I find it necessary to work with table rows in a specific,
generally user-supplied order. It could be anything really that
requires an ordering that can't come from a natural column. Most of
the time this involved manipulating a
Hey,
I dont understand the difference between this ORDINALITY option and
adding a row_number() over() in the SELECT.
Thanks,
Cheers,
Remi-C
2014-02-06 Vik Fearing vik.fear...@dalibo.com:
On 02/06/2014 04:16 AM, Michael Sacket wrote:
Often times I find it necessary to work with table rows
On 02/06/2014 10:00 AM, Rémi Cura wrote:
Hey,
I dont understand the difference between this ORDINALITY option and
adding a row_number() over() in the SELECT.
WITH ORDINALITY will give you something to order by. You should never
do row_number() over () because that will give you potentially
Ok, thanks ^^
Cheers,
Rémi-C
2014-02-06 Vik Fearing vik.fear...@dalibo.com:
On 02/06/2014 10:00 AM, Rémi Cura wrote:
Hey,
I dont understand the difference between this ORDINALITY option and
adding a row_number() over() in the SELECT.
WITH ORDINALITY will give you something to order
On Wed, Feb 5, 2014 at 7:16 PM, Michael Sacket msac...@gammastream.com wrote:
Often times I find it necessary to work with table rows in a specific,
generally user-supplied order. It could be anything really that requires an
ordering that can't come from a natural column. Most of the time
On Feb 6, 2014, at 2:23 AM, Vik Fearing wrote:
On 02/06/2014 04:16 AM, Michael Sacket wrote:
Often times I find it necessary to work with table rows in a specific,
generally user-supplied order. It could be anything really that requires an
ordering that can't come from a natural column.
On 07/02/14 05:43, Michael Sacket wrote:
On Feb 6, 2014, at 2:23 AM, Vik Fearing wrote:
On 02/06/2014 04:16 AM, Michael Sacket wrote:
Often times I find it necessary to work with table rows in a specific,
generally user-supplied order. It could be anything really that requires an
ordering
On 02/06/2014 11:57 AM, Gavin Flower wrote:
On 07/02/14 05:43, Michael Sacket wrote:
On Feb 6, 2014, at 2:23 AM, Vik Fearing wrote:
On 02/06/2014 04:16 AM, Michael Sacket wrote:
Often times I find it necessary to work with table rows in a
specific, generally user-supplied order. It could be
Greetings,
Often times I find it necessary to work with table rows in a specific,
generally user-supplied order. It could be anything really that requires an
ordering that can't come from a natural column. Most of the time this involved
manipulating a position column from the client
10 matches
Mail list logo