Mark W the SQL Geek

Opinions, experiences and information about SQL and the databases that process the language, from a guy who's been at it for over 20 years.

Friday, November 23, 2018

Happy Fibonacci Day!

Happy Fibonacci day, here is how to generate a Fibonacci sequence in PostgreSQL
on November 23, 2018
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Pages

  • Home
  • Privacy Policy
  • Cookie Policy

About Me

My photo
MWrynn
DevOps Developer (and a sometimes backend dev/data eng/DBA depending when you catch me), passionate about SQL and evangelizing the subject. -- Big proponent of maximizing your database investment by taking advantage of the powerful features it has to offer. Big opponent of using your database as a generic, lowest common denominator bit bucket. -- Favorite phrase: "When in doubt, test it out." There's a lot of misinformation out there regarding SQL, especially performance claims. Anyone can test their favorite hypotheses by running a test! Yeah science!
View my complete profile

Blog Archive

  • ►  2025 (4)
    • ►  May (4)
  • ►  2024 (5)
    • ►  December (2)
    • ►  September (1)
    • ►  March (1)
    • ►  February (1)
  • ►  2023 (3)
    • ►  November (3)
  • ►  2021 (1)
    • ►  May (1)
  • ►  2020 (3)
    • ►  August (2)
    • ►  January (1)
  • ►  2019 (9)
    • ►  October (1)
    • ►  June (4)
    • ►  May (1)
    • ►  March (1)
    • ►  February (1)
    • ►  January (1)
  • ▼  2018 (12)
    • ►  December (1)
    • ▼  November (1)
      • Happy Fibonacci Day!
    • ►  October (1)
    • ►  September (3)
    • ►  August (1)
    • ►  March (1)
    • ►  February (3)
    • ►  January (1)
  • ►  2017 (6)
    • ►  May (1)
    • ►  April (1)
    • ►  March (4)
  • ►  2016 (17)
    • ►  November (2)
    • ►  July (1)
    • ►  June (3)
    • ►  May (1)
    • ►  April (2)
    • ►  March (4)
    • ►  February (3)
    • ►  January (1)
  • ►  2015 (11)
    • ►  December (1)
    • ►  May (1)
    • ►  March (5)
    • ►  February (4)
  • ►  2014 (8)
    • ►  September (1)
    • ►  August (2)
    • ►  March (3)
    • ►  February (2)
  • ►  2013 (12)
    • ►  December (1)
    • ►  November (3)
    • ►  September (2)
    • ►  August (2)
    • ►  April (1)
    • ►  March (3)
  • ►  2012 (4)
    • ►  August (1)
    • ►  February (1)
    • ►  January (2)
  • ►  2011 (24)
    • ►  December (1)
    • ►  November (3)
    • ►  September (1)
    • ►  August (2)
    • ►  July (1)
    • ►  June (4)
    • ►  May (3)
    • ►  April (3)
    • ►  March (2)
    • ►  February (2)
    • ►  January (2)
  • ►  2010 (8)
    • ►  December (1)
    • ►  November (1)
    • ►  October (2)
    • ►  August (1)
    • ►  June (1)
    • ►  March (1)
    • ►  February (1)
  • ►  2009 (2)
    • ►  December (1)
    • ►  March (1)
  • ►  2008 (1)
    • ►  December (1)
  • ►  2007 (6)
    • ►  July (2)
    • ►  May (1)
    • ►  April (3)

Labels

  • 10
  • 11g
  • 12c
  • 12cR2
  • add column
  • alert log
  • Amazon
  • analytics
  • ANSI
  • apgdiff
  • api
  • argh
  • AskTom
  • auditing
  • awesome
  • AWS
  • big data
  • bind
  • bind variables
  • bonkers
  • BoobyTrap
  • Books
  • bug
  • caching
  • cartoon
  • cern
  • character sets
  • chat
  • clone
  • cluster
  • clustered
  • clustering
  • collations
  • column
  • column store
  • columns diffs
  • common table expressions
  • comparison
  • connor mcdonald
  • constructing rows
  • crazy
  • CTE
  • CTEs
  • danger
  • database of the year
  • db-engines
  • db2
  • ddl
  • default
  • diff
  • distinct on
  • dynamic columns
  • EC2
  • emacs
  • errors
  • evil
  • Evil MySQL Feature
  • example
  • expdp
  • export
  • features
  • foreign keys
  • game
  • generate series
  • generation
  • history
  • IGNORE
  • impdp
  • import
  • in
  • incremental refresh
  • independence
  • index
  • indexes
  • inheritance
  • INSERT IGNORE
  • installation
  • ISO
  • Java
  • JDBC
  • join
  • joins
  • JOOQ
  • JSON
  • just bind
  • key-value
  • length
  • limitation
  • linux
  • lisp
  • load balancing
  • locking
  • locks
  • logging
  • mandelbrot
  • maria
  • mariadb
  • MATCH_RECOGNIZE
  • materialized views
  • merge
  • microsoft
  • MODIFY
  • MS SQL
  • MSSQL
  • mwrynn
  • MySQL
  • MySQL.com
  • newlines
  • News
  • numeric
  • odd
  • online recovery
  • optimization
  • optimizations
  • optional
  • oracle
  • parallel
  • parameter
  • parameterization
  • parameters
  • paramterization
  • partitioned aggregates
  • partitioning
  • performance
  • pgpool
  • pgpool-ii
  • pi
  • pi day
  • pivot
  • pl/sql
  • postgres
  • postgresql
  • preparedstatement
  • query
  • query rewrite
  • quiz
  • random
  • rant
  • RDS
  • recovery
  • recursive
  • recursive query
  • reddit
  • reference
  • refresh
  • release
  • REPLACE
  • REPLACE INTO
  • reporting
  • retrosheet
  • rewrite
  • row
  • row constructor
  • row pattern matching
  • schema
  • scripts
  • sequences
  • series
  • shared memory
  • shmmax
  • sparkfun
  • speed
  • SQL
  • SQL injection
  • SQL Server
  • sqlplus
  • standard SQL
  • sucks
  • Sybase
  • syntax
  • table
  • test
  • Tom Kyte
  • trick
  • unpivot
  • upgrade
  • upgrading
  • upsert
  • usebindvariables
  • value
  • version
  • versioning
  • weird
  • whygod
  • window
  • window functions
  • windowing
  • with
  • with recursive
  • wonky

Report Abuse

Subscribe To

Posts
Atom
Posts
Comments
Atom
Comments

Followers

Search This Blog

MySQL metadata locks on child tables in foreign key relationships, and how Postgres compares

Popular Posts

  • The Benefits of Using Row Constructors! [MySQL]
      In the world of SQL, sometimes you need to conjure up rows of literal data out of thin air, instead of pulling data from an existing table...
  • Arrays vs. IN-lists in SQL Using JDBC: Techniques and a Glance Under the Hood
    Intro: Alright, so say you want to run a query that has the WHERE clause WHERE id IN (...) from your Java program, using JDBC, where the co...
  • What have Oracle Materialized Views got that PostgreSQL ones don't?
    This comes up once in a while. Just because DBMS x has a Feature ABC, doesn't mean it's the same as Feature ABC on DBMS y. Postgres ...
Watermark theme. Powered by Blogger.