Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

I have a sql query that I am having a hard time converting into a postgresql function

Hello <@443116621054345226>!
This thread has been automatically created from your message in <#843999948717555735> a ``few seconds ago``.

Pinging <@&951828363943759883> so that they see this as well!

**Want to unsubscribe from this thread?**
Right-click the thread in Discord (or use the ... menu) and select **Leave Thread** to unsubscribe from future updates.

**Want to change the title?**
Use the `/title` command!

**We have solved your problem?**
Click the button below to archive it.

SELECT s.i AS first_missing_id
FROM generate_series(1, 1000) s(i)
WHERE NOT EXISTS (SELECT 1 FROM thingiverse_raw WHERE raw_id = s.i )LIMIT 1;

| first_missing_id |
| ---------------- |
| 41               |

I would also like the generate_series(1, 1000) arguments as arguments in the postgresql functions

I don't see a function here, can you show an example of what the function creation looks like?

Thread was archived by <@443116621054345226>. Anyone can send a message to unarchive it.