Test for array slice? - Mailing list pgsql-general

From Peter Fein
Subject Test for array slice?
Date
Msg-id 42A080B9.7070901@pobox.com
Whole thread Raw
Responses Re: Test for array slice?  (Joe Conway <mail@joeconway.com>)
List pgsql-general
Hi-

I want to do something like this (pardon my pseudocode):

A=ARRAY[4, 5, 6, 7, 8]
B=ARRAY[5, 6]

is_sliceof(A, B), i.e., there exists a slice of A that equals B.  My
best thought ATM is to convert both to strings and use pattern matching
- any better ideas?

--Pete


pgsql-general by date:

Previous
From: Tony Caduto
Date:
Subject: Re: PG Lightning Admin running on Linux via WINE 2005524
Next
From: "Joshua D. Drake"
Date:
Subject: Re: PG Lightning Admin running on Linux via WINE 2005524